🚀 News: We are launching the Kontext Labs Platform Pilot! Click here to join our pilot program.

Data Analysis Expressions to Create Static Tables in PowerBI

DATATABLE

StaticTable1 = DATATABLE("IntCol",INTEGER,"StringCol",STRING,{{1,"User1"},{2,"User2"}})

The above expression generates a table with two columns IntCol and StringCol:

Open-Live-Writer/fbe7e1add61b_11E2C/image_thumb.png

UNION

StaticTable2 = UNION (      ROW ( "IntCol",1, "StringCol", "User1"),      ROW ( "IntCol",2, "StringCol", "User2") )

The above expression generates a table with same structure:

Open-Live-Writer/fbe7e1add61b_11E2C/image_thumb_1.png

CALENDAR

StaticTable3 = CALENDAR(date(2018,05,20),TODAY())

This expression generates a table with one column as the following screenshot shows:

Open-Live-Writer/fbe7e1add61b_11E2C/image_thumb_2.png