Forum Discussion
Creating a cumulative bar chart with additional categories
Hi,
PBI file attached.
Yes this works but what if i have data that is in the future?
Currently the cumulative values are based on the DATESYTD function but what do i do as soon as i have data that is planned to be after the current year?
Super UserWhat problem are you facing because of dates that belong to the future years? Share the download link of the file, show the problem clearly and the expected result.
Sorry for not clarifying.
So im talking about the same table but the dates of would not be of - like in my earlier example - 2022 but in 2025. Like this:Date Total MonthlyAmount Subcategory RuntimeMonths Jan 25 40 4 Dep 1 10 Jan 25 36 3 Dep 3 12 Feb 25 55 5 Dep 2 11 Feb 25 40 4 Dep 1 10 Feb 25 36 3 Dep 3 12 Mar 25 55 5 Dep 2 11 Mar 25 40 4 Dep 1 10 Mar 25 36 3 Dep 3 12 Apr 25 40 4 Dep 1 10
And the table is still supposed to look like the one you created but now were talking about 2025.- Ashish_Mathur
My solution should work irrespective of the year of the entries in the Date column.
Whenever i change the year of the dates to 2025 the cumulative T measure doesnt do anything. It stays empty.
I used your pbi file and only changed the dates and it doesnt work.