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"
)
AlGrant's avatar
AlGrant
Frequent Visitor
3 years ago

Hi, thanks for the help, unfortunately that still flags items as at risk that are complete but have blank on-prem  decom dates

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!