#table Function in Power Query

The #table function is used to create a table value from columns and rows.

Syntax

#table(columns as any, rows as any) as any

Example:

Power Query M

let
  MyTable = #table({"EmployeeID", "Name", "Marks"}, {
      {1, "Ashish", 56},
      {2, "Katrina", 130},
      { 3, "Alia",38},
      {4, "Vicky", 48},
      {5, "Mohini", 28},
      {6, "Meenakshi", -29},
      {7, "Esha", 100},
      {8, "Anjali", 0}
    }
  )
in
  MyTable

The output of the above code is shown below:

Previous Next