Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Since today the IF-Statement in PowerBI does not work properly anymore.
This formula returns the following error:
Column = IF(Table1[Column1] = 1, "A", "B")
The syntax for '"A"' is incorrect. (DAX(IF(Table1[Column1] = 1. "A", "B"))).
Solved! Go to Solution.
Update: I solved it by putting the logical test into brackets:
Column = IF((Table1[Column1] = 1), "A", "B")
Update: I solved it by putting the logical test into brackets:
Column = IF((Table1[Column1] = 1), "A", "B")
User | Count |
---|---|
102 | |
84 | |
77 | |
70 | |
67 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |