Help with IF statement and multiple conditions

[AlGrant]

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 column and a Start Date column. I want to flag items as at risk if they are not "complete" ("in progress" or "not started") and are past their start date. I would also like to flag items as as at risk if they blank start date, but not those which are complete.

Below is what I have so far but that does not exclude the completed items that have no date:

At Risk Decom date (y/n)

= IF('CMI Application Tracker'[Decom Status (remove blanks)] <> "Complete"

&& 'CMI Application Tracker'[On-Prem Decom Date] < TODAY() || 'CMI Application Tracker'[On-Prem Decom Date] =BLANK() , "Yes", "No")

[grantsamborn]

Hi @AlGrant 

I'm not quite sure if I understand completely.

Maybe try a calculated column like this:

At Risk Decom date (y/n) = 
IF(
    ('CMI Application Tracker'[Decom Status] <> "Complete"
        && 'CMI Application Tracker'[On-Prem Decom Date] < TODAY()
    )
    ||
    ('CMI Application Tracker'[Decom Status] = "Complete"
        && 'CMI Application Tracker'[On-Prem Decom Date] = BLANK()
    ),
    "Yes",
    "No"
)

Let me know if that helps.

[AlGrant]

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

[grantsamborn · Accepted solution]

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]

Thank you! 

[grantsamborn]

If I change it to <> BLANK(), then the results don't match your 3rd column (which I thought was the expected result.)

pbix: https://drive.google.com/file/d/1FuN_LCenyMu27R5vD7RTnYlKUMzaIyqc/view?usp=share_link