Forum Discussion

AlGrant's avatar
AlGrant
Frequent Visitor
3 years ago
Solved

Help with If statement with And and OR included

I'm trying to flag items in our app tracker list as at risk (Yes or No) based on timeline and running into problems. FYI - I am new to Powerbi.    I have a list of items with Status column and a St...
Need Help
Tutorial Requests
  • grantsamborn's avatar
    grantsamborn
    3 years ago

    Hi AlGrant 

    Can you give this a try?

    At Risk start date (y/n) = 
IF(
    ( 'CMI Application Tracker'[Cloud Migration Status] = "Not Started"
        && 'CMI Application Tracker'[Migration Start Date] < TODAY() )
    ||
    ( 'CMI Application Tracker'[Cloud Migration Status] <> "Complete"
        && 'CMI Application Tracker'[Migration Start Date] = BLANK() ),
    "Yes",
    "No"
)