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
giovanni_figuei
Frequent Visitor

Two values in IF FALSE DAX

Hi im trying to put two values in the IF FALSE part of  the IF statement.

My situation requires that i show the "NOT OK" and a value from a column if the expression is false. I get the SINTAX ERROR with this code below.

giovanni_figuei_1-1642613754387.png

I dont even know if it is possible to do that but i will apreciate any help. Thank you for your time.

 

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@giovanni_figuei 

try to use "&" to connect.

"NOT OK" & 'EXAMPLE'[EXAMPLE]





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ryan_mayu
Super User
Super User

@giovanni_figuei 

try to use "&" to connect.

"NOT OK" & 'EXAMPLE'[EXAMPLE]





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




amitchandak
Super User
Super User

@giovanni_figuei , What is that additional column doing

if(12>0, "OK" , "NOT OK")

 

Use Switch for multiple  conditions

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

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.