Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
Just wandering if this is even possible. I have a matrix table and I want to show the 'Sales' by MonthYear and the 'Average Sales' by Quarter.
This would be the desired output
I managed to get it working using MonthOffsets in the date table and creating 3 measures to calculate the Sales for each month, but I am not sure if there is a way to dynamically update the measure names to correspond to the Quarter selected in the slicer,
or build this differently altogether. at the moment it does not show the Month name.
any help appreciated.
sample pbix attached
https://drive.google.com/file/d/11z-JiVqRB6-ehYekr9a0AJWGHua2apB9/view?usp=sharing
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |