Forum Discussion

tobiasnndr's avatar
tobiasnndr
Frequent Visitor
8 years ago
Solved

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. (...
Data Modeling
  • tobiasnndr's avatar
    tobiasnndr
    8 years ago

    Update: I solved it by putting the logical test into brackets:

     

    Column = IF((Table1[Column1] = 1), "A", "B")
tobiasnndr's avatar
tobiasnndr
Frequent Visitor
8 years ago

Update: I solved it by putting the logical test into brackets:

 

Column = IF((Table1[Column1] = 1), "A", "B")