Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Can someone fix my formula ? it now returns an error: Operator or expression '( )' is not supported in this context.
HP = IF(OR(Adressen[R.N.A.]="R40";(Adressen[R.N.A.]="R42"));"";
IF(Adressen[HomePassed]<>BLANK();"Ja";
IF(OR(Adressen[status naam]="2.0";
(Adressen[status naam]="2.1";
(Adressen[status naam]="4.10";
(Adressen[status naam]="4.11";
(Adressen[status naam]="4.12";
"Ja";
"Nee"
))))))))
Solved! Go to Solution.
Please try the formula below.
HP = IF((Adressen[R.N.A.]="R40" || Adressen[R.N.A.]="R42");""; IF(Adressen[HomePassed]<>BLANK();"Ja"; IF((Adressen[status naam]="2.0"|| Adressen[status naam]="2.1"|| Adressen[status naam]="4.10"|| Adressen[status naam]="4.11"|| Adressen[status naam]="4.12");"Ja";"Nee" ) ) )
Regards,
Charlie Liao
Please try the formula below.
HP = IF((Adressen[R.N.A.]="R40" || Adressen[R.N.A.]="R42");""; IF(Adressen[HomePassed]<>BLANK();"Ja"; IF((Adressen[status naam]="2.0"|| Adressen[status naam]="2.1"|| Adressen[status naam]="4.10"|| Adressen[status naam]="4.11"|| Adressen[status naam]="4.12");"Ja";"Nee" ) ) )
Regards,
Charlie Liao
@RvdHeijden use http://www.daxformatter.com/
to identify issues the above link however also check the documentation
https://msdn.microsoft.com/en-us/library/ee634951.aspx
or only takes 2 arguments, in this scenario better to use switch
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |