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.

 

OptionColumn1 Column2Conditional Column
Green21Below
Green22Same
Green23Above
Blue21Below
Blue22Same
Blue23Above
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"
)

2 Replies

  • 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,