Forum Discussion

AlGrant's avatar
AlGrant
Frequent Visitor
3 years ago
Solved

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

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

 

ItemMigration StatusDecom StatusActual Program Status
1CompleteCompleteComplete
2In ProgressNot StartedIn Progress
3CompleteNot StartedDecom Pending
4CompleteIn progressDecom Pending
5Not StartedNot StartedNot Started
Need Help
Tips and Tricks
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    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.

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    3 years ago

    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.