Forum Discussion
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 Query Editor:
Thanks, Michael
mikedebruyn try this, tweak it as you see fit
if [Ticket Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), -10) then 1 else 0
5 Replies
mikedebruyn try this, tweak it as you see fit
if [Ticket Date] >= Date.AddDays(Date.From(DateTime.LocalNow()), -10) then 1 else 0Awesome, thank you, but I am in DirectQuery mode and it won't let me use that 😞
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!
mikedebruyn if you are using DQ mode you cannot add a custom column in PQ. Today is a DAX function, not M function. Why not add this column at the source instead of Power BI?
