Forum Discussion
edhans
Community Champion
Community ChampionReference a column to filter a nested table in Power Query?
I am trying to filter a column in a nested table by a column in the query that holds the nested table. In the [All Rows] column are nested tables that have the year and main account number and amou...
If i understand the problem correctly
each let myyear=[Year] in Table.SelectRows([All Rows], each [Year] >= myyear))
Zubair_MuhammadCommunity Champion
Community Champion
If i understand the problem correctly
each let myyear=[Year] in Table.SelectRows([All Rows], each [Year] >= myyear))
AnkitBI
Solution Sage
Solution SageWas thinking around the same. Thanks for the learnings :)