Forum Discussion
tobiasnndr
8 years agoFrequent Visitor
DAX IF Formula
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"))).
Update: I solved it by putting the logical test into brackets:
Column = IF((Table1[Column1] = 1), "A", "B")
1 Reply
- tobiasnndrFrequent Visitor
Update: I solved it by putting the logical test into brackets:
Column = IF((Table1[Column1] = 1), "A", "B")