Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Data is very simple: a Day of Registration (1, 2, 3, etc), which does not fall on the same date every year; a Term (2022/02, 2021/02, 2020/02 for example), and a # of credit hours for that day and term. We need to make a crosstab showing Day of Registration as a Row, Term as a Column, and credit hours as the value. But, we also need to show the % of change between the max year and each individual year. In this sample max year is 2022/02. So columns would be 2022/02 credit hours, then 2021/02 credit hours, then % change between credit hours of those two terms, then 2021/02 credit hours, then % change between 2022/02 and 2020/02. Currently this report is prepared manually, and end user wants to put it in Power BI. But I can't figure out how to lay this out. Any help is appreciated. (Max year is selected from a slicer by user.)
Reg Day | Term | CH | HC |
1 | 2022/04 | 100 | 25 |
2 | 2022/04 | 150 | 32 |
3 | 2022/04 | 320 | 125 |
1 | 2021/04 | 120 | 41 |
2 | 2021/04 | 170 | 52 |
3 | 2021/04 | 510 | 122 |
1 | 2020/04 | 140 | 29 |
2 | 2020/04 | 220 | 62 |
3 | 2020/04 | 670 | 200 |
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |