Creating a Table Using Table Constructor

  • Table constructors are expressions that create tables. 
  • Every time a constructor is evaluated, a new table is created. A constructor can be used to create an empty table or to create a table and initialize some of its fields. 
  • It is created using curly brackets [ {……}].
  • It is created in Data view in Power BI Desktop.

Scenario 1: Table containing single column and multiple rows.


A screenshot of a cell phone

Description automatically generated

Scenario 2: Table containing multiple columns and single rows.


Scenario 3: Table can be created using DAX measures and multiple rows and columns.

There are two measures already created which are Cost and Profit.


Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.