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. (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

  • tobiasnndr's avatar
    tobiasnndr
    Frequent Visitor

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

     

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