Compare multiple columns in same table

Tan_LC — Fri, 05 Jul 2024 06:37:06 GMT

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

Re: Compare multiple columns in same table

bhanu_gautam — Fri, 05 Jul 2024 06:43:23 GMT

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

topic Re: Compare multiple columns in same table in DAX Commands and Tips

Compare multiple columns in same table

Re: Compare multiple columns in same table