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.

Output:

A screenshot of a cell phone Description automatically generated

Scenario 2: Table Containing Multiple Columns and Single Rows.

Output:

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.

Output:

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.

Email Us Or Contact Us