Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |