Would someone be able to tell me why my SWITCH(TRUE() function with multiple conditions is returing wrong anwers? Just look at row 2 in of the attached screenshot - it should return "Group 4", instead it's returning "Group 2".
Thank you for your help,
Go to Solution.
@Fizzy_Mojito , use the brackets (condition || condition) && (condition || condition).
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
View solution in original post
Yep, in logical statements && comes first in order of operations before ||, like multiplication comes before addition.
A && B || C = ( A && B ) || C just like A * B + C = ( A * B ) + C.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!