Forum Discussion
Apple08
Helper IV
3 years agoLookup 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...
Apple08
Helper IV
3 years agoThanks, I like a DAX to include the rest as well, e.g. 'Girl' or 'playing (girls) then 'Girl'
Smalfly
Responsive Resident
3 years agoThen the SWITCH function is what you are looking for:
https://learn.microsoft.com/en-us/dax/switch-function-dax
- Apple083 years ago
Helper IV
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.