New conditional Column based on two status columns in the same table

[AlGrant]

Hello,

I'm a new Powerbi user and am having issues creating a measure, any help would be appreciated.

Within a single table I have two columns for item status, one based on Migration Status and the other Decom Status.

I would like to create a new column called "Actual Program Status" based on the below criteria:

• If Migration and Decom status are “Complete” = Complete
• If migration status does not equal “not started” and decom is “Not started” = In Progress
• If migration status is "Complete" and decom status is not ”Complete” = Decom Pending
• If Migration Status is "Not Started" and Decom Status is "Not Started" then = Not Started

Item	Migration Status	Decom Status	Actual Program Status
1	Complete	Complete	Complete
2	In Progress	Not Started	In Progress
3	Complete	Not Started	Decom Pending
4	Complete	In progress	Decom Pending
5	Not Started	Not Started	Not Started

[jdbuchanan71 · Accepted solution]

@AlGrant 

You can do that with a calcualted column using a SWITCH statement like this.

Actual Program Status = 
SWITCH ( 
    TRUE(),
    YourTable[Migration Status] = "Complete" && YourTable[Decom Status] = "Complete", "Complete",
    YourTable[Migration Status] <> "Not Started" && YourTable[Decom Status] = "Not Started", "In Progress",
    YourTable[Migration Status] = "Complete" && YourTable[Decom Status] <> "Complete", "Decom Pending",
    YourTable[Migration Status] = "Not Started" && YourTable[Decom Status] = "Not Started", "Not Started",
    "Other"
)

You would just need to change the name of the table to match your model.

[AlGrant]

Thanks you for your help @jdbuchanan71!