Forum Discussion

Tomo2709's avatar
Tomo2709
Regular Visitor
7 years ago
Solved

Nested switch statements?

Hi  I have two conditional columns [FROMDASHBOARDSTATUS] AND [FROMOFFSHORESTATUS]   I am trying to apply some logic to different scenarios depending upon the result in either [FROMDASHBOARDSTATUS]...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    I think adding IF would be sufficient, also I'm not sure about order of conditions for the Unknown - is it as you expected?

    FINALSTATUS =
IF (
    'PFUpdates'[FROMOFFSHORESTATUS] = "Unknown",
    "Unknown",
    SWITCH (
        'PFUpdates'[FROMDASHBOARDSTATUS],
        "Approved - Modified", 'Panel Firm Updates'[FROMOFFSHORESTATUS],
        "Approved - Paid in Full", IF (
            ISBLANK ( 'Panel Firm Updates'[FROMOFFSHORESTATUS] ),
            "Transferred to EDM",
            'Panel Firm Updates'[FROMOFFSHORESTATUS]
        ),
        "Unapproved", "Awaiting approval in Dashboard",
        "Disputed", "Disputed in Dashboard",
        "Rejected", "Rejected in Dashboard",
        "Reversal", "Reversal in Dashboard",
        BLANK (), "No Record",
        "Unknown", 'Panel Firm Updates'[FROMOFFSHORESTATUS]
    )
)
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

I think adding IF would be sufficient, also I'm not sure about order of conditions for the Unknown - is it as you expected?

FINALSTATUS =
IF (
    'PFUpdates'[FROMOFFSHORESTATUS] = "Unknown",
    "Unknown",
    SWITCH (
        'PFUpdates'[FROMDASHBOARDSTATUS],
        "Approved - Modified", 'Panel Firm Updates'[FROMOFFSHORESTATUS],
        "Approved - Paid in Full", IF (
            ISBLANK ( 'Panel Firm Updates'[FROMOFFSHORESTATUS] ),
            "Transferred to EDM",
            'Panel Firm Updates'[FROMOFFSHORESTATUS]
        ),
        "Unapproved", "Awaiting approval in Dashboard",
        "Disputed", "Disputed in Dashboard",
        "Rejected", "Rejected in Dashboard",
        "Reversal", "Reversal in Dashboard",
        BLANK (), "No Record",
        "Unknown", 'Panel Firm Updates'[FROMOFFSHORESTATUS]
    )
)
Tomo2709's avatar
Tomo2709
Regular Visitor
7 years ago

Hey Stachu - great to hear from you again.  Ill give your solution a go - will get back to you in a tick :)

 

Paul 

  • Tomo2709's avatar
    Tomo2709
    Regular Visitor
    7 years ago

    Hi

     

    I know i have said it before in other posts but ill say it again - you are a star.  Thank you so much.  I never thought about an if statement :) !

     

    Paul