Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago

Calculated Column: IF function

Hi all,   How do I created a calculated column using DAX for the below:   Team = IF 'Username' = 'Adam Thompson' THEN 'London'     etc...   I want a new column called team and each team depen...
Need Help
Show and Tell
Tips and Tricks
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago
Hi HenryJS ,
 
According to your description, you can use the SWITCH function. But this work may be troublesome. You need to group each user.
 
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.