This site uses cookies to deliver our services. By using this site, you acknowledge that you have read and understand our Cookie and Privacy policy. Your use of Kontext website is subject to this policy. Allow Cookies and Dismiss

Data Analysis Expressions to Create Static Tables in PowerBI

26 views 0 comments last modified about 18 days ago Raymond Tang

lite-log power-bi

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

Related pages

Power Analytics with Power BI and Google Analytics

80 views   0 comments last modified about 18 days ago

Power BI is my favourite BI and visualization tool as it is very simple yet powerful. It doesn’t only support traditional data sources like databases, CSV, JSON, XML and etc., but also supports emerging sources that are available in HDFS, Spark, R, Salesforce, Google Analytics and cloud platforms...

View detail

Power BI Analytics - Connect to DBMS and Card

16 views   0 comments last modified about 18 days ago

Power BI supports connecting to most of the DBMS databases such as SQL Server, Oracle, Teradata, MySQL, DB2, Sybase, Snowflake, Google BigQuery, Impala and etc. This page summarizes the steps to connect to SQL Azure and to create the following part of the sample dashboard of this series: ...

View detail

Add comment

Please login first to add comments.  Log in New user?  Register

Comments (0)

No comments yet.