Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |