Forum Discussion

CA's avatar
CA
Frequent Visitor
9 years ago
Solved

Inconsistency with DateTime and accepted Operators?

I'm new to PowerBI and PowerQuery so this problem I've run into is really confusing me. What I'm trying to do is get a count of tickets created within the last 14 days and eventually plot the amount ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    With the second formula, you omitted DateTime.Date. It should be:

     

    if [CreatedDate] > Date.AddDays(DateTime.Date(DateTime.LocalNow()), -14) then "1" else "0"
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

With the second formula, you omitted DateTime.Date. It should be:

 

if [CreatedDate] > Date.AddDays(DateTime.Date(DateTime.LocalNow()), -14) then "1" else "0"
  • CA's avatar
    CA
    Frequent Visitor
    9 years ago

    Thank you SO much, this was killing me! I mulled over and over the syntax for an embarrassingly long time...

     

    Thanks again!