Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Nested IF statement in custom column

I'm relatively new to PowerBI and having a little trouble wih the syntax for transposing a nested IF statement from Excel. 

 

My Excel formula reads:

=IF(H2="NULL", "None" , IF(H2>B2,"Late", IF((I2<-7), "Early", "Good" )))

 

Trying to follow logic from previous posts, but seeminly always coming up with a syntax error.

 

Any help would be greatly appreciated!

 

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

     

    You should provide some sample data in a format which people can copy, otherwise we are doing with our imagination...not sure if you want to add a custom column  in M or DAX, modify the Table name and Column name accordingly

    here is M - Power Query Custom Column, you click Add Column -> Custom Column in GUI

    if [H] = null then "None"
else if [H]>[B] then "Late"
else if [I] <-7 then "Early"
else "Good"

    here is DAX Calculated column

    Column = IF(ISBLANK([H]),"None",
IF([H]>[B],"Late",IF([I]<-7,"Early","Good")))

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 

     

    You should provide some sample data in a format which people can copy, otherwise we are doing with our imagination...not sure if you want to add a custom column  in M or DAX, modify the Table name and Column name accordingly

    here is M - Power Query Custom Column, you click Add Column -> Custom Column in GUI

    if [H] = null then "None"
else if [H]>[B] then "Late"
else if [I] <-7 then "Early"
else "Good"

    here is DAX Calculated column

    Column = IF(ISBLANK([H]),"None",
IF([H]>[B],"Late",IF([I]<-7,"Early","Good")))

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Please have a try.

    Create a measure.

     

    Measure = var null_ = IF(SELECTEDVALUE('Table'[H2])=BLANK(),"None",IF(SELECTEDVALUE('Table'[H2])>SELECTEDVALUE('Table'[B2]),"late",IF(SELECTEDVALUE('Table'[I2])<-7,"Early","Good")))
return null_

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.