Forum Discussion

mirzay's avatar
mirzay
Icon for Helper I rankHelper I
11 years ago
Solved

New Column formula with IF no longer accepted

This was working yesterday but no longer today.   I added a column that tells the difference between 2 dates. However, if a date is null, I would like to use today's date for that. This works in Po...
  • curth's avatar
    curth
    11 years ago

    In the posted screen shot, you're in a Power Query/M context and not a DAX context. As such, the expression you actually want is probably something like this:

     

    = if [ClosedDateTime] = null then Duration.TotalDays([ClosedDateTime] - [CreatedDateTime]) else Duration.TotalDays(DateTime.LocalNow() - [CreatedDateTime])
jeffrey_wang's avatar
jeffrey_wang
Icon for Power BI Team rankPower BI Team
11 years ago

Can you post the screen shot with the error or the error message text?

Ribban's avatar
Ribban
New Member
11 years ago

This error is what I get. expression: IF name was not recognized check spelling

IF_errro_in_Power_BI.png

 

//Håkan

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    11 years ago

    I think the reason for the error is becuase it is case sensitive, if you change it to lower case (if) it will work. 

     

    Thanks,