Forum Discussion
Lookup multiple values in a column
Hi All I need a DAX to look up the values in column A then create another column B as shown below. I know I can use if(search in DAX however I just wonder is there a quicker way like someth...
Thanks, I like a DAX to include the rest as well, e.g. 'Girl' or 'playing (girls) then 'Girl'
Then the SWITCH function is what you are looking for:
https://learn.microsoft.com/en-us/dax/switch-function-dax
I wonder search function is more appropriate to look for any specific value within the text. As I need to look for the specific value within long text.