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))
hello, i have the same case. is there any better way to have the same output but with better perfomance...
for my data source, working on nested table like this take a lot of time.
Unfortunately not. Nested tables can be a source of performance issues. Not really a big deal on a few thousand records, but when you get into the hundreds of thousands or millions, it can be a show stopper.