Filter on date table to show records till today

[TechR21]

Hi,

I created a date table that i join with another table in my dataset with the following code;

= {Number.From(#date(2023,1,1))..Number.From(#date(2024,12,31))}

so this date table contains data till 31-12-24

However when creating a visual i only want to see data till current date but dont want to adjust this for all reports with a filter on each report.

I try to add a filter like below but i keep getting errors;

= Table.SelectRows(#"previous step", each [Date] <= Date.From(DateTime.LocalNow())

date only contains date and no time

[amitchandak]

@TechR21 , Hope you created this as a new step not as a new column

#"previous step" = <Code>,

#"select Data" = Table.SelectRows(#"previous step", each [Date] <= Date.From(DateTime.LocalNow()))

[TechR21]

this error i get:

[TechR21]

i got it working 🙂

[akos_skutovics]

try Date.From(DateTime.LocalNow()) instead of DateTime.LocalNow()

[TechR21]

yes I adding a new step to filter but  cant seem to make it work