Forum Discussion

YerlaSDU's avatar
YerlaSDU
Helper I
3 years ago
Solved

Create new column based on existing

Hi Folks,

 

I have a column name e1subclass

 

How can I create the new Column msdclass with cases,

if e1subclass = BDEE, mdsclass = FABD

elseif e1subclass = BDAH, mdsclass = FABD

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    YerlaSDU , Based on what I got a new column in dax

     

    if([e1subclass] in {"BDEE", "BDAH"} , "FABD", [e1subclass] )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    YerlaSDU , Based on what I got a new column in dax

     

    if([e1subclass] in {"BDEE", "BDAH"} , "FABD", [e1subclass] )

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    3 years ago

    Hi YerlaSDU ,

     

    You can try this method:

    MDS class = SWITCH(TRUE(), OR('Table'[E1 SubClass] = "BDEE",'Table'[E1 SubClass] = "BDAH"),"FABD")

    The result is:

    Hope this helps you.

    Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.