Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
a simple sintaxe like this used to work.... i dont know its not working anymore after the few lastest updates
Teste= IF (BaseFat2[Cod custumer] IN (4433;1740;5808;5685) ; "shopping";"market" )
the IN statment is not working anymore, i cant even use OR... and i dont want to use multiple if conditionals
Can someone help me to solve this or build a new formula??
Solved! Go to Solution.
hi, try using this DAX
Test = IF ( Table1[Codcustomer] = 4433 || Table1[Codcustomer] = 1740 || Table1[Codcustomer] = 5808 || Table1[Codcustomer] = 5685, "shopping", "market" )
hi, try using this DAX
Test = IF ( Table1[Codcustomer] = 4433 || Table1[Codcustomer] = 1740 || Table1[Codcustomer] = 5808 || Table1[Codcustomer] = 5685, "shopping", "market" )
it worked -.-
do you know why " IF xxx IN (z,y,a,b)" stoped working?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |