SWITCH and boolean doesn't work as expected? Why not?

[Anonymous]

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

[mahoneypat]

Please 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

[Fowmy · Accepted solution]

@Anonymous 

Use the IN function

Team 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

[Anonymous]

you beauty. thanks that works great! solution accepted and kudos given