Using a named range in a filter

[jimrward]

currently I have a large amount of process data, 150k source, I want to get the number of processes by lane since last PM date
I reduce the columns down to lane, date, I have a named range in another tab called LastPM I create an additoinal column and flood it with LastPM

= Table.AddColumn(#"Changed Type", "LastPM", each Excel.CurrentWorkbook(){[Name="LastPM"]}[Content]{0}[LastPM])

I then test date against this new column and set to either 0 or 1

= Table.AddColumn(#"Changed Type1", "SincePM", each if [Date] > [LastPM] then 1 else 0)

I then filter SincePM=1 and do additional processing count per day etc by lane

What I would like to do instead of the above is filter Date by LastPM, but i get an error either due to syntax or not allowed
I create a dummy filter entry using todays date and then in advanced view I paste in [Name="LastPM"]}[Content]{0}[LastPM]

Some guidance would be great many thanks

 

[alex78]

Hi jimrward,

try

= let x = Table.ToRows(Excel.CurrentWorkbook(){[Name="LastPM"]}[Content]){0}{0} in Table.SelectRows(#"Changed Type", (y)=> y[Date] > x)

Regards