Forum Discussion
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...
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
provide more information related to tables.