DAX - Nested IFs

[Excel Jason]

Hello,

I have a DAX formula that's essentially performing two calculations; However, although both work separately, when combined the second formula seems to over-write the second.

The desired outcome: If Project Name = "OKC to FLC" check for the two stated service provides and result a "Y" or "N". IF NOT, perform an identical check for the "MID to JAL' project name and return a "Y" or "No". If a given line item does not fit in these two buckets, return a blank.

What I'm receiving is a result is correct "Y" and "N" separation for "MID to Jal" but the first logical check for "OKC to FLC" returns blanks when it should return a "Y" or "N".

I think some syntax error is over-writing the first logic and only returning the second. Thoughts?

 

[ExceLoki]

=IF(IF([@projectname]="OKC to FLC",IF(OR([@serviceprovider]="BKOH",[@serviceprovider]="8KYL"),"N","Y"))="",IF([@projectname]="MID to JAL",IF(OR([@serviceprovider]="FTAN",[@serviceprovider]="FTAN"),"N","Y")))

right now you have IF([@projectname]="OKC to FLC",IF(OR([@serviceprovider]="BKOH",[@serviceprovider]="8KYL"),"N","Y"))="" as your first IF. this if will always be false as it will return N="" or Y="".

also it appears your second section of service provider is checking for the same value twice

try this to see if it gets the results you're looking for:

=IF(IF([@projectname]="OKC to FLC",IF(OR([@serviceprovider]="BKOH",[@serviceprovider]="8KYL"),"N","Y"),"")<>"",IF([@projectname]="OKC to FLC",IF(OR([@serviceprovider]="BKOH",[@serviceprovider]="8KYL"),"N","Y"),""),IF([@projectname]="MID to JAL",IF(OR([@serviceprovider]="FTAN",[@serviceprovider]="FTAN"),"N","Y"),""))