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,...
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
Fowmy
Super User
Super UserAnonymous
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
you beauty. thanks that works great! solution accepted and kudos given