Another IF AND statement question with more than 2 variables :-)

[unclejemima]

I've got this exact senario what I would typicall use a "If(OR..." statement, but I can't because I can only do 2 arguments...I think I need to use SWITCH but I'm not sure.  Can someone give me the DAX formula for the following...

If trandata[account] number is between 6001-6098, or 7030, 7926 or 9071 then retreive the values from trandata[amount]

Please and thank you!!!

[Vvelarde · Accepted solution]

@unclejemima

Hi, lets try with this calculated column:

M =
IF (
 Trandata[Account] >= 6001
 && Trandata[Account] <= 6098
 || Trandata[Account] = 7030
 || Trandata[Account] = 7926
 || Trandata[Account] = 9071;
 Trandata[Amount]
)

Regards

Victor

[Vvelarde]

@unclejemima

A shorter version will be:

M =
IF (
    Trandata[Account] >= 6001
        && Trandata[Account] <= 6098
        || Trandata[Account] IN { 7030; 7926; 9071 };
    Trandata[Amount]
)

Regards

Victor

[unclejemima]

Thanks Vvelarde for the super quick reply!!

I tried the both options...but getting an error

The syntax for ';' is incorrect. (DAX(IF ( Trandata[Account] >= 6001 && Trandata[Account] <= 6098 || Trandata[Account] IN { 7030; 7926; 9071 }; Trandata[amount]))).

Do I have something wrong?

I pasted your exact DAX in.

[unclejemima]

I  changed the 

;

 to a 

,

and I think that might do it...trying now...

[unclejemima]

I was able to get this to work...

M = 
IF (
 Trandata[account] >= 6001
 && Trandata[Account] <= 6098
 || Trandata[Account] = 7030
 || Trandata[Account] = 7926
 || Trandata[Account] = 9071,
 Trandata[Amount],blank()
)

I like the shorter option you proposed, but could not get it to work.

[Vvelarde]

@unclejemima

Yeah is Regional Settings. My settings is with ; 

Regards

Victor

[unclejemima]

lol.  Darn regional settings lol.

Thank you though. Formula is working awesome :-)!!!!!