Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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")))
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.
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")))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |