Forum Discussion

drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago
Solved

Calculated Column with multiple IF Else Then

Hi All, I have two calculated Columns which I created in the Data view from other Columns. The Calculated Columns are [Number of Days] and [Action]   Number of Days Action Result 4 2 Gre...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    drrai66

    The DAX is like

    Column =
SWITCH (
    TRUE (),
    yourTable[Number of Days] < 5
        && yourTable[Action] <= 2, "Green",
    yourTable[Number of Days] < 8
        && yourTable[Action] <= 2, "Yellow",
    yourTable[Number of Days] >= 8
        && yourTable[Action] <= 2, "Red",
    yourTable[Number of Days] <= 15
        && yourTable[Action] <= 3, "blue",
    yourTable[Number of Days] >= 15
        && yourTable[Action] > 3, "Orange",
    "Violet"
)
drrai66's avatar
drrai66
Icon for Resolver I rankResolver I
8 years ago

Hi SRINIVT,

I am Totally new to Power BI and I am stuck on this. Can you please do one more favour and write the Formula. I had tried earlier but could not do, so I posted here.

Thanks

Deepak

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

drrai66

The DAX is like

Column =
SWITCH (
    TRUE (),
    yourTable[Number of Days] < 5
        && yourTable[Action] <= 2, "Green",
    yourTable[Number of Days] < 8
        && yourTable[Action] <= 2, "Yellow",
    yourTable[Number of Days] >= 8
        && yourTable[Action] <= 2, "Red",
    yourTable[Number of Days] <= 15
        && yourTable[Action] <= 3, "blue",
    yourTable[Number of Days] >= 15
        && yourTable[Action] > 3, "Orange",
    "Violet"
)
  • drrai66's avatar
    drrai66
    Icon for Resolver I rankResolver I
    8 years ago

    Thanks and Many Many Thanks. Learnt something new from you and Solved my Problem. I used your Formula at Many many places in my dataset and it works like Charm!!!

    Thanks

    Deepak

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Glad to help. :)

  • Hema_Gupta's avatar
    Hema_Gupta
    Frequent Visitor
    2 years ago

    Hi, 

    Hope this helps.