Power Query to Dynamically Filter By Current Year and Beyond

[legalhustler]

I am scraping a web page with a list of holidays with Power Query. The web page has a list of current and prior year holidays. I want to dynamically filter out prior years based on the current year we are in. I want to also keep future years. So in the table below I want filter out 2018 and 2019 (since we're in 2020) and show only 2020, 2021 and 2022. I don't want to click the filter drop down and simply remove prior years, but need a dynamic way (IF statement to check if we're in current year?) because this something that needs to happen every year.

Year	Data
2018	Table [Not Yet Expanded]
2019	Table [Not Yet Expanded]
2020	Table [Not Yet Expanded]
2021	Table [Not Yet Expanded]
2022	Table [Not Yet Expanded]

 

[sandy666]

maybe adapt

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Condition = Table.AddColumn(Source, "Condition", each [Year] >= Date.Year(DateTime.LocalNow())),
    True = Table.SelectRows(Condition, each ([Condition] = true)),
    RC = Table.RemoveColumns(True,{"Condition"})
in
    RC

Year		Year
2018		2020
2019		2021
2020		2022
2021
2022

update your profile about Excel version and OS

 

[legalhustler]

Exactly what Ineeded - custom column with Date.Year(DateTime.LocalNow())

Thanks!

 

[sandy666]

You are welcome
and
update your profile about Excel version and OS

 

[legalhustler]

You are welcome
and
update your profile about Excel version and OS

Thanks - just updated

 

[sandy666]

Thanks for updating
Have a nice day