Forum Discussion
Solved
Probably an easy one - why doesn't this Today function work?
Just trying to get a column that will sort out the dates for the past 10 days for another operation. Should be a really simple statement? Here is what I have while trying to add a column the Power ...
mikedebruyn try this, tweak it as you see fit
if [Ticket Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), -10) then 1 else 0
mikedebruyn try this, tweak it as you see fit
if [Ticket Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), -10) then 1 else 0
OK, with significantly more work than expected, I converted the report to import, but still getting an error without much direction from PowerBI on what is wrong, formula doesn't throw an error, but this is what I am getting now:
Sorry, just figured it out, there was an extra space in the column name, removed that and now it works, thank you!