Raymond Raymond

Data Analysis Expressions to Create Static Tables in PowerBI

event 2018-06-02 visibility 652 comment 0 insights toc
more_vert
insights Stats
toc Table of contents

DATATABLE

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

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

image

UNION

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

The above expression generates a table with same structure:

image

CALENDAR

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

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

image

More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts