Data Analysis Expressions to Create Static Tables in PowerBI

Raymond Tang Raymond Tang 0 724 0.28 index 6/2/2018

DATATABLE

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

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

https://api.kontext.tech/resource/1609db69-b7f6-5d1c-99f9-12e1c3f18447

UNION

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

The above expression generates a table with same structure:

https://api.kontext.tech/resource/7655e47d-3628-5caa-84ad-c21e44e6a751

CALENDAR

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

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

https://api.kontext.tech/resource/a215b5ff-d6cd-57ab-9a01-933c88ed2979

lite-log power-bi

Join the Discussion

View or add your thoughts below

Comments