languageEnglish

Data Analysis Expressions to Create Static Tables in PowerBI

visibility 470 comment 0 access_time 4 years ago

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

info Last modified by Raymond 4 years ago copyright This page is subject to Site terms.

Subscribe newsletter

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

More from Kontext

visibility 3321
thumb_up 1
access_time 10 months ago
Power BI Analytics - Connect to DBMS and Card
visibility 624
thumb_up 0
access_time 2 years ago