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:

UNION

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

The above expression generates a table with same structure:

CALENDAR

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

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