Forum Discussion

benn's avatar
benn
New Member
7 years ago
Solved

Power Query - How to resolve variable/column scope, or how to reference column inside a table.

  In Power BI, I have a table that has a column of tables. See screenshot below:       Inside of the column called ThirdTable, each has a table that has the final information I’d like to gra...
  • v-chuncz-msft's avatar
    7 years ago

    benn,

     

    You may add step below.

    = Table.TransformColumns(#"Added Custom", {"ThirdTable", each Table.SelectRows(_, each ([Name] = "Title"))})