Forum Discussion
Larry_Wang
Helper I
Helper IHow to change values with DAX
Hi Everyone, I have a table below and I want to create a new column called category with only two items, fruit & other. How to do this with DAX? ID Name CATEGORY 1 APPLE fruit 2 ...
Hi,
Here is an example:Category = IF(Category[Name] in {"TABLE","PEN"},"OTHER","FRUIT")
I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!
ValtteriN
Community Champion
Community ChampionHi,
Here is an example:
Category = IF(Category[Name] in {"TABLE","PEN"},"OTHER","FRUIT")
I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!
Larry_Wang