Forum Discussion
MurielT
9 years agoFrequent Visitor
How to use the OR Operator with DAX
Hi Can someone please help me to capture the accurate expression on DAX. I would like to use the OR operator for multiple values like below but sounds I do something bad as I have an error message....
- 9 years ago
Hi,
It seems something is wrong with the other part of your formula. Please post your formula here. You can replace the confidential part. Or maybe you can try operator “in” like this: 'Product'[Product Line Identifier] in {“6J”, “2C”, “KV”} (Values in brace).
Best Regards!
Dale
v-jiascu-msft
Microsoft Employee
9 years ago
Hi,
It seems something is wrong with the other part of your formula. Please post your formula here. You can replace the confidential part. Or maybe you can try operator “in” like this: 'Product'[Product Line Identifier] in {“6J”, “2C”, “KV”} (Values in brace).
Best Regards!
Dale
MurielT
9 years agoFrequent Visitor
Hi Dale
Thanks a lot
It works now !
Have a nice day
Muriel
- v-jiascu-msft9 years ago
Microsoft Employee