Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tobiasnndr
Frequent 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"))).

1 ACCEPTED SOLUTION
tobiasnndr
Frequent Visitor

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

 

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

View solution in original post

1 REPLY 1
tobiasnndr
Frequent Visitor

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

 

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.