From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Referencing a list as a column in a table

Referencing a list as a column in a table

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Referencing a list as a column in a table

“

- [Instructor] Continuing on from the previous video, there's a third method that allows us to create lists by referring to a column in a table either as the table name or the step name. Since this method does not directly reference a list in the expression, we do not immediately recognize it as a function to generate a list. In the M Language Objects Power BI file, we're now going to add the Population by Zip Code query from the U.S Census Power BI file so we can test out how to create list objects from an existing table. Copying over the query allows us to consolidate our test work in M Language into a single Power BI file. Here's the M code from the Population by Zip Code query. I copy this M code. And in our current Power BI file, I select New Source, Blank Query. I leave the formula bar blank and I select the Advanced Editor window. And I paste all of the M code into the text space. Hit Done. And I…

Contents