Forum Discussion

Larry_Wang's avatar
Larry_Wang
Icon for Helper I rankHelper I
4 years ago
Solved

How 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 ...
DAX
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    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!

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

You probably want a switch for something like this. For example,

Region =
VAR Loc = Table1[Location]
RETURN
    SWITCH (
        TRUE (),
        LEFT ( Loc, 7 ) = "America", "AMERICA",
        LEFT ( Loc, 4 ) = "Asia", "APAC",
        LEFT ( Loc, 4 ) = "Euro", "EU",
        LEFT ( Loc, 3 ) = "US/", AMERICA
    )

 

Larry_Wang's avatar
Larry_Wang
Icon for Helper I rankHelper I
4 years ago

Hi AlexisOlson ,

 

Cool! It works for me. Thanks a lot for the help.

 

Larry