Forum Discussion
SWITCH and boolean doesn't work as expected? Why not?
Hi Everyone
I am trying to use a switch statement to include a column for team location, based on a team identifier integer.
Team Location = SWITCH(TRUE(),'Team Map'[Team Order]= 1||2||3||4,"London")
However my results are as follows:
I have ensured the format of [Team Order] is whole number. the boolean should return FALSE for any number not 1 - 4 so how come I am getting this result?
thanks
Anonymous
Use the IN functionTeam Location = SWITCH(TRUE(),'Table (2)'[Column1] IN {1,2,3,4},"London")If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
3 Replies
Anonymous
Use the IN functionTeam Location = SWITCH(TRUE(),'Table (2)'[Column1] IN {1,2,3,4},"London")If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS ? to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and ExcelPlease try an expression like this instead
Team Location = SWITCH(TRUE(),'Team Map'[Team Order] in {1,2,3,4},"London")You could also consider a Groups column if you have other Cities to assign to numbers.
https://exceleratorbi.com.au/grouping-in-power-bi-desktop-without-using-dax/
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
