if logic Help

Hi paw1 ,

Please have a try.

Create a column.

high priority =
IF (
    table[Reached Active?] = "Yes"
        && table[Reached Priority?] = "Yes"
        && table[Reached High Priority?] = "Yes"
        && table[Completed/Portfolio?] = "No",
    "No",
    IF (
        table[Status (adjust)] = "On hold"
            || table[Status (adjust)] = "Onhold-Tracked",
        "Yes",
        IF (
            table[Status (adjust)] = "Monitor"
                || table[Status (adjust)] = "Active"
                || table[Status (adjust)] = "Priority",
            "Yes",
            "No"
        )
    )
)

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.