If DAX language (powerPivot)

[Aliq2014]

Hello I need assistance,

I have the following code:

=IF(AG_TBL[SUPLoc]=AG_TBL[WORKLoc], "Target","Non-target")

Is working fine, however, here is a drawback. If both SupLoc and WorlLoc are blank I'm returning as “target”. Is there a way I can:
A) Identify if both fields are blank to leave them blank
B) Identify if SUPLoc=WORKloc identify them as “target’, else “non-target”

I’m new to powerpivot and i have difficulty translating the code.

Thanks

 

[Aliq2014]

I'm looking for nested if statements:

IF SupLoc = WorkLoc then "target"
If SupLoc =" " and WorlLoc = " " then "No Value/Blank"
else "non-target"

Any help is appreciated

 

[olivierhbh]

Hello Aliq,

I guess you could just do:

=
IF (
    AG_TBL[SUPLoc] <> BLANK ()
        && AG_TBL[SUPLoc] = AG_TBL[WORKLoc],
    "Target",
    "Non-target"
)

 

[Aliq2014]

Hello Aliq,

I guess you could just do:

=
IF (
    AG_TBL[SUPLoc] <> BLANK ()
        && AG_TBL[SUPLoc] = AG_TBL[WORKLoc],
    "Target",
    "Non-target"
)

Thanks for the response. I should have explained a little more better. I apologize, I basically need to look for 3 possible scenarios:
1) If (SupLoc = WorkLoc) then “Target”
2) Elseif (SupLoc =”” and WorkLoc = “”) then “No Value/Blank”
3) Elseif (SupLoc <> WorkLoc) then “Non-Target”

The code you provided looks ok but I just discovered that there are instances that suploc and workloc aren't equal and I need to set them as non target.

 

[olivierhbh]

Indeed I didn't handle the case number 2).

Here is what you wanted originally, nested ifs:

=
IF (
    G_TBL[SUPLoc] = BLANK ()
        && AG_TBL[WORKLoc] = BLANK (),
    BLANK (),
    IF (
        G_TBL[SUPLoc] <> BLANK ()
            && AG_TBL[WORKLoc] <> BLANK (),
        "Target",
        "Non-target"
    )
)