Data Analysis Expressions to Create Static Tables in PowerBI

2018-06-02 lite-logpower-bi

DATATABLE

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

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

/project/power-bi/resources/1609DB69-B7F6-5D1C-99F9-12E1C3F18447.webp

UNION

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

The above expression generates a table with same structure:

/project/power-bi/resources/7655E47D-3628-5CAA-84AD-C21E44E6A751.webp

CALENDAR

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

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

/project/power-bi/resources/A215B5FF-D6CD-57AB-9A01-933C88ED2979.webp