Forum Discussion

AlGrant's avatar
AlGrant
Frequent Visitor
3 years ago
Solved

Help with IF statement and multiple conditions

Hello,   I'm trying to flag items in our app tracker list as at risk based on timeline and status and could use some guidance. I am new to Powerbi.    I have a list of items along with Status col...
Need Help
Tutorial Requests
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    After re-reading, I guess all that have a status of Complete are not a risk.

    At Risk Decom date (y/n) 2 = 
IF(
    'CMI Application Tracker'[Decom Status] <> "Complete"
        && OR(
            'CMI Application Tracker'[On-Prem Decom Date] < TODAY(), 
            'CMI Application Tracker'[On-Prem Decom Date] = BLANK() ),
    "Yes",
    "No"
)
grantsamborn's avatar
grantsamborn
Solution Sage
3 years ago

After re-reading, I guess all that have a status of Complete are not a risk.

At Risk Decom date (y/n) 2 = 
IF(
    'CMI Application Tracker'[Decom Status] <> "Complete"
        && OR(
            'CMI Application Tracker'[On-Prem Decom Date] < TODAY(), 
            'CMI Application Tracker'[On-Prem Decom Date] = BLANK() ),
    "Yes",
    "No"
)
AlGrant's avatar
AlGrant
Frequent Visitor
3 years ago

Thank you!