topic Cumulative DAX sum measure in DAX Commands and Tips

Cumulative DAX sum measure

miracle2023 — Wed, 06 Sep 2023 09:17:42 GMT

Hi,

Has anyone done something similar to my problem? I have a matrix table made by dimDate year and month for the upcoming 16 months starting from the current month.

Column overdue - its cases those deadline was in the past. Therefore, it is overdue and my table shows the overall count of them.

Due cases - its cases those deadline is in the future based on the deadline having a single relationship between dimdate table and my fact table deadline.

Availability - Static value meaning how many cases my team is able to handle

My methodology is shown in the attached table while predicted overdue can be negative.

Year	Month	Overdue	Due	Availibility (Static value)	Predicted Overdue
2023	9	34	54	80
2023	10		23	80	(34+23)-80
2023	11		35	80	(34+23+35)-80
2023	12		65	80	(34+23+35+65)-80
2024	01		43	80	(34+23+35+65+43)-80
2024	02		75	80	(34+23+35+65+43+75)-80

Re: Cumulative DAX sum measure

DataNinja777 — Wed, 06 Sep 2023 12:11:12 GMT

Hi miracle2023,

I've prepared the calculated columns which produce the same output as your screen print.

I've first added a helper column below:

Then, used that helper column in the dax formula for calculated column which produces your required result.

The pbix file is saved under the following link:

Cumulative sum.pbix

Re: Cumulative DAX sum measure

miracle2023 — Thu, 07 Sep 2023 06:15:10 GMT

Thank you very much for your help!