Multiple conditions in a column dax

[valerial]

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” and [Amount]>0 then “Reversal”

else if[ACCOUNTNUM] = “B30002,B12323” and [Amount]>0 then "Release"
else “Accrual"

[amitchandak]

@valerial ,

Please try

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

[v-juanli-msft]

Hi @valerial 

Try columns below:

Column =
IF (
    [ACCOUNTNUM]
        IN {
        "B30001",
        "B34123"
    }
        && [Amount] > 0,
    "Reversal",
    IF (
        [ACCOUNTNUM]
            IN {
            "B30002",
            "B12323"
        }
            && [Amount] > 0,
        "Release",
        "Accrual"
    )
)

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[valerial]

Hi Maggie,

Your solution showed an error in the In

[v-juanli-msft · Accepted solution]

Hi @valerial 

Please show your error.

Best Regards

Maggie

[valerial]

[v-juanli-msft]

Hi @valerial 

I don't see column name in the left of the "=", it should be there.

also, you need add one more ")" at the end of the formula.

Best Regards

Maggie

[valerial]

Maggie I had some silly typo! it works thank you!

[valerial]

Hi Maggie.  Now I have this issue above.  

[HotChilli]

The code has to be very explicit with the logic test

If I was you , I would get the account code bit working first then introduce the balance test.

Is this an 'OR' test?

if ([ACCOUNTNUM] = “B30001" OR [ACCOUNTNUM] = "B34123” ,