Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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 |
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |