Filter a column from earliest date in a column to 700 days out --- Power Query

[Plukey]

Ive been asked (not sure if this can even be done) filter a Date column 700 days from the earliest date in the column The Date column has work due from now 2021 - 2025. I did a filter listed below. Ideally, im looking for somthing more automatic.

= Table.SelectRows(#"Promoted Headers", each [#"PLN-BD SchFin"] >= #date(2019, 11, 1) and [#"PLN-BD SchFin"] <= #date(2024, 4, 30))

 

[JGordon11]

try

= let maxdt = Date.AddDays(List.Min(#"Promoted Headers"[#"PLN-BD SchFin"]),700) in Table.SelectRows(#"Promoted Headers", each [#"PLN-BD SchFin"]<= maxdt)

 

[Plukey]

Thank you, I copied and placed your line in the advance editor and its a no go got a bunch of errors... my column starts 11/29/2021 and ends 4/29/2024 which is roughly 700 days out...but the data will increase further out very soon.

 

[Plukey]

Ive tried this and notta.

= Table.SelectRows(#"Promoted Headers", let earliest = List.Min(#"Promoted Headers"[PLN ActFin]) in each [PLN ActFin] = earliest) and(#"Promoted Headers", each Date.IsInNextNDays([PLN ActFin], 700))

 

[JGordon11]

It's not going to work pasting that into the advanced editor; you would need to paste something like this under the #"Promoted Headers" step.

FilterStep =  let maxdt = Date.AddDays(List.Min(#"Promoted Headers"[#"PLN-BD SchFin"]),700) in Table.SelectRows(#"Promoted Headers", each [#"PLN-BD SchFin"]<= maxdt)

 

[Plukey]

It's not going to work pasting that into the advanced editor; you would need to paste something like this under the #"Promoted Headers" step.

FilterStep =  let maxdt = Date.AddDays(List.Min(#"Promoted Headers"[#"PLN-BD SchFin"]),700) in Table.SelectRows(#"Promoted Headers", each [#"PLN-BD SchFin"]<= maxdt)

Perfect, thank you!

 

[Plukey]

It was late & I thought it worked, but unfortunately its not. I placed the line under Promoted headers .

 

[Plukey]

= Table.SelectRows(#"Promoted Headers", let earliest = List.Min(#"Promoted Headers"[#"PLN-BD SchFin"]) in each [#"PLN-BD SchFin"] = earliest or Date.IsInNextNDays([#"PLN-BD SchFin"], 675))

I did this using the filter, kinda works but leaves out 5 months, i cant figure out how to use the DateAdd.days

 

[JGordon11]

In the user interface paste it as in post #2

In advanced editor paste it as in post #5

 

[Plukey]

Pasted in the user interface as in Post#2 &

And Post#5 in advance editor got (Token Eof expected)

Apologies, i feel that I'm struggling on this