Forum Discussion
Solved
SWITCH function help (does not support comparing values of type true/false)
Hi I have a measure that is supposed to be determining whether certain values are met, and should sort them into either tiers 1, 2, 3, or 4. I am getting an error that says the switch function does n...
Hi abeirne ,
Could you try this? 🙂
SA Anc/Car = IF( [ANC $/ Car SA] >= 43.50, Switch( TRUE, [ANC $/ Car SA] <= 49.49, 1, [ANC $/ Car SA] >= 49.50 && [ANC $/ Car SA] <= 55.99 , 2, [ANC $/ Car SA] >= 56 && [ANC $/ Car SA] <= 65.99, 3, [ANC $/ Car SA] >= 66.00, 4 , 0) ,0)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi abeirne ,
Could you try this? 🙂
SA Anc/Car = IF( [ANC $/ Car SA] >= 43.50, Switch( TRUE, [ANC $/ Car SA] <= 49.49, 1, [ANC $/ Car SA] >= 49.50 && [ANC $/ Car SA] <= 55.99 , 2, [ANC $/ Car SA] >= 56 && [ANC $/ Car SA] <= 65.99, 3, [ANC $/ Car SA] >= 66.00, 4 , 0) ,0)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Yes the 'true' works! Would you be willing to explain why this works? Thank you for your help. 🙂
Hi abeirne ,
I hope it's okay if I just post you some links that I think are great to read up on:
How To Use SWITCH True Logic Function In Power BI | Enterprise DNAPower BI: Use DAX Switch Function to Make IF Functions Easier (pragmaticworks.com) (especially the video is great)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/