Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone, I'm trying to sort the following values to arrange the matrix with the SWITCH function to avail:
Sort = SWITCH('Merged Data'[Action], "Market", 1, "Region", 2, "National", 3, "Received", 4)
I'm trying to get the table to look like this:
Market
- No BOM Order Found
- BOM in Draft
- Pending Market Review
- Review Shortage
Region
- Pending Regional Review
- ...
- ...
- ...
National
- ...
Received
- ...
Anyone aware of a simpler way to sort rows/columns?
Many thanks!
Solved! Go to Solution.
You would need to create one of two things:
See this article for a more detailed overview of how to sort by another column rather than just alphabetically.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou would need to create one of two things:
See this article for a more detailed overview of how to sort by another column rather than just alphabetically.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |