Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm working on a dax and I would regroup two measures in one to use it on a matrix table in order to display them in the following format :
The measures that I'm using are :
Nbp = CALCULATE(SUM('Forecast'[Nje]))
Nbpre = CALCULATE(SUM('Time_records'[Nb Hours])/8))
So the purpose of regrouping these to measures is to show the results, for example, in January 2020 the Nbp measure will appear and in January 2021 Nbpre will appear as I show in the figure above.
I tried to show it on the matrix table but I can't find the results!
Do you have any ideas? Any tips?
Thank you in advance
Regards,
You are overcomplicating things.
- merge your measures into one measure that calculates differently based on the year.
- add a sort column to your dates table that allows you to sort the yearmonth column according to your display needs and then wire it in via "sort by other column"
User | Count |
---|---|
67 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
122 | |
42 | |
39 | |
26 | |
24 |