Create new column based on existing

[YerlaSDU]

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

[v-yinliw-msft]

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.

[amitchandak · Accepted solution]

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

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