Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I have a table joined to a calendar table. I want to display the cumulative number of postings in the axis and cumulative balance in the values field of a line graph. I am been using cumulative DAX formulas from the forums but I am struggling to get this to display correctly.
Any support would be appreciated.
Regards,
ImranAmi
Solved! Go to Solution.
Please refer to this post to get the cummulative sum.
https://community.powerbi.com/t5/Power-Query/Cumulative-YTD-total/m-p/832712
If this helps, mark it as solution.
If not, please provide the sample data to assist.
Thanks you for your response. The following DAX has helped for the sum:
However for the cumulative count, I just realised I am struggling to create this visual because you cannot use a measure in the X Axis but need to use a calculated column. My source data is from a push dataset and I am limited to measures only. Unless there is another method I may need to request the data source provider to include a cumulative count.
https://community.powerbi.com/t5/Desktop/Using-a-measure-as-the-axis-of-a-column-chart/td-p/398394
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |