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've got values for targets for a whole month, and with a days delay I get sales numbers.
I want to create a matrix showing the index of sales each day over the month compared to the daily targets. This is easily done, however I want the total in the bottom to be the cumulative index of these daily sales and targets up to the last reported day (yesterday).
At the moment the total in the bottom shows the index of the sales up to yesterday compared to the target for the whole month, which makes the total useless.
Is there a way to solve this issue?
Solved! Go to Solution.
Ended up finding a solution after a while of struggle. But thanks for the offer of help!
@Sperling ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Ended up finding a solution after a while of struggle. But thanks for the offer of help!
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
93 | |
91 | |
76 | |
69 |