Forum Discussion

valerial's avatar
valerial
Icon for Helper I rankHelper I
6 years ago
Solved

Multiple conditions in a column dax

I am trying to select multiple values within one text and write mulitple ifs within one column something like this..   but this does not work how do i do this if ([ACCOUNTNUM] = “B30001,B34123” an...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi valerial 

    Please show your error.

    Best Regards

    Maggie

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

valerial ,

Please try

Switch (true(),
[ACCOUNTNUM] in { "B30001","B34123"} && [Amount]>0 , "Reversal" ,
[ACCOUNTNUM] in {"B30002","B12323"} && [Amount]>0 , "Release",
"Accrual"
)