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

106 views 0 comments last modified about 7 months ago Raymond Tang

lite-log power-bi


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

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



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

The above expression generates a table with same structure:



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

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


Related pages

Advanced analytics on big data with Azure - Tutorial

287 views   0 comments last modified about 5 months ago

Microsoft Azure provides a number of data analytics related products and services. It allows users to tailor the solutions to meet different requirements, for example, architecture for modern data warehouse, advanced analytics with big data or real time analytics. The following diagram sho...

View detail

Use Google Cloud BigQuery as Data Source in Power BI

541 views   0 comments last modified about 6 months ago

BigQuery is Google’s serverless data warehouse in Google Cloud. Power BI can consume data from various sources including RDBMS, NoSQL, Could, Services, etc. It is also easy to get data from BigQuery in Power BI. In this article, I am going to demonstrate how to connect to BigQuery to create...

View detail

Power Analytics with Power BI and Google Analytics

268 views   0 comments last modified about 7 months 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

88 views   0 comments last modified about 7 months 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.


  • enquiry[at]