if logic Help

[paw1]

Hi,

I have below if logic inTableau. Please can you help me to convert same in Power BI.

high priority=if [Reached Active?]="Yes" and [Reached Priority?]="Yes" and [Reached High Priority?]="Yes" and [Completed/Portfolio?]="No" then
if [Status (adjust)]="On hold" or [Status (adjust)]="Onhold-Tracked" then "Yes" else
if [Status (adjust)]="Monitor" or [Status (adjust)]="Active" or [Status (adjust)]="Priority" then "Yes"
else "No" END
END
else "No" END

[Anonymous · Accepted solution]

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.