Multiple if Statements across multiple columns in Power Bi (Public)

PHOTO EMBED

Thu Sep 02 2021 06:12:28 GMT+0000 (Coordinated Universal Time)

Saved by @cnewnham #vba

# Actions - Status All (fix) = SWITCH(
    TRUE(),
    '2 Non-conformances - Combined'[# Actions - Assigned]="Assigned" && '2 Non-conformances - Combined'[# Actions - Not Complete (outcome works, source data needs correction)]=0, "Completed",
    '2 Non-conformances - Combined'[# Actions - Assigned]="Assigned" && '2 Non-conformances - Combined'[# Actions - Not Complete (outcome works, source data needs correction)]>=1, "Not Completed",
    '2 Non-conformances - Combined'[# Actions - Assigned]="Not Assigned", "Pending",
    "Other"
)
content_copyCOPY

https://blog.enterprisedna.co/using-advanced-dax-for-multiple-if-statement-in-power-bi/