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 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-msft's avatar
    v-chuncz-msft
    Community Support

    benn,

     

    You may add step below.

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