Conditional Column using DAX

[Rosario]

Hi All, help please, I want to add a Conditional Column as the sample below using DAX. I would appreciate your support. Thank U. Rosario.

Option	Column1	Column2	Conditional Column
Green	2	1	Below
Green	2	2	Same
Green	2	3	Above
Blue	2	1	Below
Blue	2	2	Same
Blue	2	3	Above

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix fie.

Conditional column CC =
SWITCH (
    TRUE (),
    Data[Column1] > Data[Column2], "Below",
    Data[Column1] < Data[Column2], "Above",
    Data[Column1] = Data[Column2], "Same"
)

[Rosario]

Thanks so much Jihwan, it worked perfectly. Much appreciated. Kind regards,