Creating a cumulative bar chart with additional categories

I recreated what you did in this file but with the changed date.
Now the edited version doesnt show the data for the acumulated values.
You can see what i mean here:

https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=drive_link
(Hope this link works)

Change the calendar table formula to

Calendar = CALENDAR(MIN(Data[Date]),MAX('Future Data'[Date]))

Hope this helps.

Almost, this works when i have all the date in the same year what if one of the categories is in a different year? 
Like this:

Then this happens:

How do i make it add up the same way?

Share the download link of the PBI file with that specific dataset and my measures already written.  Show the problematic visual in that PBI file.

https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=drive_link

Hi,

Based on the data in the file, show the expected result in a Table format very clearly.

Sorry i messed up the data in the file i shared.
Here is a correct one:
https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=sharing

And this is what i need it to look like(with bars for each month instead of the three points of course):

So it always shows the accumulated monthly amount for each department and whenever there is an additional amount it just adds it to the amount of that department.
Also i might need it with a dynamic number of departments.

Thank you very much

I do not see 3 dots there.  Everything seems fine to me.

The image i sent is not the finished graph but only an edited version of what i want it to look like. Thats why i said the 3 dots in the image are only because i didnt want to create a bar for the months between april 2025 and january 2026. For practical reasons but they should of course be in the final visual.

For Dep 3, information is available only for JFM 2026.  There if i swap Year and Month on the X-axis, this is the image i get (with which i see nothing wrong)

Yes, but i need ALL of the monthly amount to be added up in every month after they are added.
In the ss you shared it resets after each year. I would like it to carry on the data from the previous years and departments.

Yes, thank you very much thats what i have been looking for.

You are welcome.