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

[benn]

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.

[v-chuncz-msft · Accepted solution]

@benn,

You may add step below.

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