Data Analysis Expressions to Create Static Tables in PowerBI

access_time 3 years ago visibility340 comment 0

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

local_offer lite-log local_offer power-bi
info Last modified by Raymond at 3 years ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Want to publish your article on Kontext?

Learn more

Kontext Column

Created for everyone to publish data, programming and cloud related articles.
Follow three steps to create your columns.


Learn more arrow_forward

More from Kontext

local_offer Azure local_offer power-bi

visibility 2354
thumb_up 1
access_time 3 years 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 shows a ...

Use Google Cloud BigQuery as Data Source in Power BI

local_offer plot local_offer power-bi local_offer bigquery

visibility 9520
thumb_up 0
access_time 3 years 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 ...

local_offer power-bi local_offer google-analytics

visibility 4052
thumb_up 0
access_time 3 years 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 ...

About column

Posts and tutorials about Power BI.

rss_feed Subscribe RSS