Forum Discussion
Solved
Reference 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))
If i understand the problem correctly
each let myyear=[Year] in Table.SelectRows([All Rows], each [Year] >= myyear))
Was thinking around the same. Thanks for the learnings :)