Forum Discussion

indhu's avatar
indhu
Helper III
8 years ago
Solved

Handle null values in custom column

I have two columns which have null values I want to create a new custom column which finds the difference between them producing null values as such.    I am aware that I can convert the null value...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    sorry there was typo in my formula, it suppose to be then instead of the

     

    if [ColumnA] = null or [ColumnB] = null then null
else if  [ColumnA] < [ColumnB] then 0 
else [ColumnA] - [ColumnB]
eizquierdo's avatar
eizquierdo
Regular Visitor
7 years ago

I've searched for different ways to do IF or Case statements in power BI and keep running across folks using code simillar to the one in this thred.

 

i.e. IF logic THEN true ELSE false

 

However when I try to use this sort of function in Power BI now it requires for the IF statement to being with " IF( " and further makes it look just like it would in standard excel.

 

i.e. IF(logic,[true],[false])

 

I'm I missing something here? If there a certain setting in power bi that must be checked to adjust the functions? Was there a recent update?

 

Emilio

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago

    Hey eizquierdo,

     

    this discussion has been about "if condition then something else somethingdifferent" this is the syntax in the M language used by PowerQuery, you mentioned the more EXCEL like IF(condition, trueresult, falseresult) syntax used in DAX.

     

    Regards,
    Tom