Need some help with my formula ;) whoes Game ?

[RvdHeijden]

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"
))))))))

[v-caliao-msft · Accepted solution]

@vanessafvg,

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

[vanessafvg]

@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