Forum Discussion

Rosario's avatar
Rosario
Helper I
3 years ago
Solved

Conditional Column using DAX

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...
Rosario
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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"
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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's avatar
    Rosario
    Helper I
    3 years ago

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