Need to select column of a Nested Table.

[Nash]

I have a situation where I am peforming left outer join on two tables.

I need to select one column from each table/query, the problem is the second table becomes a nested table in the first one.

I want to know if there is any other way than using Table.ExpandTableColumn(). Is there any way to directly access column of a nested table.

[v-chuncz-msft · Accepted solution]

@Nash,

You may also try LOOKUPVALUE Function in DAX.

[PattemManohar]

@Nash It will be great if you can post some sample data and expected output as well.