Forum Discussion

SBR1D's avatar
SBR1D
Icon for Helper III rankHelper III
2 years ago
Solved

How to ignore blank values in switch statement

Hello

 

I am using a switch statement which is working fine except for if the result if 0 where it seems to pick up blank values. I have tried adding the ISBLANK function but it does not solve  the problem. 

 

no date this month / last month / 2 months = SWITCH(
    TRUE, 'Learning Plan'[month since last activity]= 0 , "Activity in this month",
        'Learning Plan'[month since last activity] = -1 , "Activity last month",
        'Learning Plan'[month since last activity] = -2 , "Last activity two months ago",
        iSBLANK('Learning Plan'[month since last activity]), "Last compliance active learning is blank",
        "no data")
     
Need Help
  • newtodax's avatar
    newtodax
    2 years ago

    Try this and let me know if that works for you 

    no date this month / last month / 2 months = SWITCH('Learning Plan'[month since last activity],
    0, "Activity in this month",
    -1, "Activity last month",
    -2, "Last activity two months ago",
    BLANK(), "Last compliance active learning is blank",
    "no data")

2 Replies

  • newtodax's avatar
    newtodax
    Frequent Visitor
    2 years ago

    Try this and let me know if that works for you 

    no date this month / last month / 2 months = SWITCH('Learning Plan'[month since last activity],
    0, "Activity in this month",
    -1, "Activity last month",
    -2, "Last activity two months ago",
    BLANK(), "Last compliance active learning is blank",
    "no data")