Compare multiple columns in same table

[Tan_LC]

Hi, in below table, I would like to retrieve a string value by comparing to the other 3 columns, Category, Rank & Pin with below conditions:

1. If the Rank is "OE", then the result shall be "OE".

2. If the Pin is Stud or Studless, then the result shall be "Stud" or "Studless".

3. Else, it shall follow Category, either "PR" or "LT".

No	Category	Rank	Pin	Desired Outcome
Y1	PR	RE	Others	PR
N3	PR	RE	Stud	Stud
P1	PR	OE	Others	OE
S1	LT	RE	Studless	Studless
A2	LT	RE	Others	LT

Thanks.

Regards, LC

[bhanu_gautam · Accepted solution]

@Tan_LC , You can get the desired result by creating a custome column go to modelling view select new column

dax
DesiredOutcome =
SWITCH(
TRUE(),
'YourTable'[Rank] = "OE", "OE",
'YourTable'[Pin] = "Stud", "Stud",
'YourTable'[Pin] = "Studless", "Studless",
'YourTable'[Category] = "PR", "PR",
'YourTable'[Category] = "LT", "LT",
BLANK()
)

Replace table name