Filter calendar to present day in Power Query

[rreck]

Hi all,

I've got the following problem.

I imported a calendar from Excel into my dashboard manually which also contains dates for the future. Now I need the program to filter the date column in Power Query to the present day (updating my dashboard each day in the week) without having to update the present day each time I update.

Is there some sort of function (or anything else) in Power Query that helps me to automize this?

By now I only have the following:
= Table.SelectRows(#"PreviousStep", each [Date] < #date(2024, 1, 26))

I need the numbers in the "#date"-section (year, month, day) to be taken from the sysdate automatically each time I update my data.

Thanks in advance 🙂 

[rreck · Accepted solution]

I seem to have found the answer. Change the code to
= Table.SelectRows(#"PreviousStep", each [Date] < Date.From(DateTime.LocalNow()))