topic Re: Conditional Column using DAX in DAX Commands and Tips

Conditional Column using DAX

Rosario — Sat, 03 Jun 2023 06:01:05 GMT

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

Re: Conditional Column using DAX

Jihwan_Kim — Sat, 03 Jun 2023 07:35:40 GMT

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" )

Re: Conditional Column using DAX

Rosario — Sat, 03 Jun 2023 23:09:30 GMT

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