Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

filter current date

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] ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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