Forum Discussion

MickeLearnPBI's avatar
2 years ago
Solved

Problem with Switch and more than... Any ideas?

I have tried to do a dax with switch but does not seem to be working with value under och over.   Anyone have any ideas to do it better?   [Status] = SWITCH( TRUE(), 'table'[InvestigationID] =...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Jihwan_Kim , please allow me to provide another insight:

     

    Hi MickeLearnPBI ,

     

    Based on your description, the calculated column created, refer to the following:

    Status = 
    SWITCH(
        TRUE(),
        Notifications[InvestigationID] = 0 && Notifications[DecisionID] > 0, "Notification One - investigation not opened",
        Notifications[DecisionID] > 0, "Notification two - Decision not to open investigation",
        Notifications[InvestigationID] > 0, "Actualizations processed",
        Notifications[InvestigationID] = 0, "New actualizations",
        "Closed actualizations"
    )
    

     

    Best Regards,
    Adamk Kong

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.