filter current date

[Anonymous]

Hey Hey, Dear Community,

I am try to create a dynamic filter that filters on till Today.

But unfortunatley i am doing something wrong.

= Table.SelectRows(#"Changed Type2", each [Eind datum] =< [Eind datum] .From( DateTime.LocalNow())

Do you perhaps know what i am doing wrong?

Thanks in advance,

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

It should be a function like below.

#"Filtered Rows" = Table.SelectRows(#"Changed Type2", each [Eind datum] <= Date.From(DateTime.LocalNow()))

Best Regards,
Dale