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.
Hi, I'm struggling to figure this out :
here is my table :
I'm currently displaying this previous table in a matrix by category :
Now I would like to add the total of the previous month for each month. For example in april we would have 1206 + 720 - 52 = 1872. Kinda like a cummulated quantities. The issue when I display the cumulated quantities it doesn't give me the deails of the calculation :
is there any way to display the total of the cumulated quantites but the details of the normal quantity ?
Thank you for your help
@Broly221 Well, if you do something like this: Better Running Total - Microsoft Power BI Community. You could probably get there using CONCATENATEX with a separator of UNICHAR(10) & UNICHAR(13) potentially.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |