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]

I was meaning to do one or the other, not both. If you delete that last line (FilterStep...) in the advanced editor it should work.

When working in the user interface the UI creates the step name and writes the M code for that step.

When working in the advanced editor you write the M code and have to supply the step name.

Your Custom1 step and FilterStep are identical and you only need one of them, keeping just the Custom1 step where it is should solve it.

 

[Plukey]

Works Absolutely perfect! You don't realize how much you saved me. Thank You Thank you & appreciate your patients.