Forum Discussion
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 grab. Specifically, the row with the value “Title”. See below for a screenshot of that table:
The simple query I’ve written is as follows:
let
finalRow = Table.SelectRows([ThirdTable], [Name] = "Title")
in
finalRow
The issue is that Power Query ends up searching for the [Name] column on the higher level table, and it ends up failing because there is no [Name] column on the higher level. I’d really just like to be able to reference the [Name] column from [ThirdTable]. I’d like to do something as simple as [ThirdTable].[Name] or something like that.
benn,
You may add step below.
= Table.TransformColumns(#"Added Custom", {"ThirdTable", each Table.SelectRows(_, each ([Name] = "Title"))})
1 Reply
- v-chuncz-msftCommunity Support
benn,
You may add step below.
= Table.TransformColumns(#"Added Custom", {"ThirdTable", each Table.SelectRows(_, each ([Name] = "Title"))})