Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Filter PowerBI, current date + 31 days

Hey Hey Dear Community,   I have got a little question. In the past i generated a filter, which filters on the current date.   Now i would like to add a little twist. Instead of the current dat...
Tutorial Requests
adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago

How can you get +30 days data? if you are taking the current date.

 

You can do forecasting for the next 30 days on the basis of previous data.

 

OR

 

Date.From(DateTime.LocalNow())+30)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey  @adityavighne, 

 

Thanks for your help.

I am indeed searching for something like this:Date.From(DateTime.LocalNow())+30)

 

But, unfortunately when i apply this i get an error.

 

#"Filtered Rows1" = Table.SelectRows(#"Reordered Columns", each [Eind datum] <= Date.From(DateTime.LocalNow())+30),

 

Expression.Error: We cannot apply operator + to types Date and Number.
Details:
Operator=+
Left=27/05/2019
Right=30

 

 

 

  • adityavighne's avatar
    adityavighne
    Icon for Continued Contributor rankContinued Contributor
    7 years ago

    provide more information related to tables.

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    7 years ago

    Hey Anonymous 

     

    just write your function like so:

    Table.SelectRows(#"Reordered Columns", each [Eind datum] <= Date.From(DateTime.LocalNow() + #duration(30,0,0,0)))


    Regards,

    Tom

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Wonderful 🙂 thanks.
      I am wondering how do you add OR today - 10 years?