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] =< [Eind datum] .From( DateTime.LocalNow())

 

Do you perhaps know what i am doing wrong?

Thanks in advance,

  • 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

2 Replies

  • 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

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

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale