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.
Power bi - i added a dax for a column as Column_test = IF(test[Variance]>=0 , "No-deviation" ,"Deviation") - it seems the else part is not working
Hi @RUPSY777,
I just created the calculated column as you refer in case, and it works well. Does the value of test[Variance] come from the subtraction of the another 2 field values? If yes, could you please provide the data type of this 2 fields? And is there any empty value in this 2 fields? It is better if you can share some sample data except sensitive data.
Best Regards
Rena
Seems fine. Can you share some sample data it is not working?
In between try 0.0, just to make sure numeric on both sides.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |