Forum Discussion
valerial
Helper I
Helper IMultiple 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...
v-juanli-msft
Community Support
Community SupportHi 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.
valerialHelper I
Helper IHi Maggie,
Your solution showed an error in the In
- v-juanli-msft
- 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