Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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,...
Need Help
  • Fowmy's avatar
    Fowmy
    6 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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