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:

Share :