Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Ive got a problem. I want to get multiple rules in a switch statement.. But its not working, only if u use OR-statement i can add 1 more rule..
Sample of the data/formula(its anonymized):
Solved! Go to Solution.
Thanks, this is exactly what i wanted.
I was so close to the solution haha
I have a template i use for adding a switch with muliple criteria
you can replace the && with a || to get an or statment. and just use as many colunms as is needed
Proud to be a Super User!
Thanks for your reply, but this isnt working for me. Doesnt give the output i need..
Are you able to give some sample data showing the data you have and your desired outcome
If you have a PBIX file that i could down load i can try and impliment this for you
Proud to be a Super User!
Give back a TRUE if ReferredID equals 1 of the 4 desired ID's and if the match with 1 of the UserID's...
If ReferredByID equals 1073 OR 440190 OR 39050 OR 28536
AND UserID equals 1028 OR 383575 OR 93233 OR 1013 then TRUE
else will give back FALSE everytime.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |