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 a...
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.

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.

  • AlGrant's avatar
    AlGrant
    Frequent Visitor
    3 years ago

    Thanks you for your help jdbuchanan71!