Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Creating a cumulative bar chart with additional categories

So i have basically done what is asked for in this post but as a bar chart: https://community.fabric.microsoft.com/t5/Desktop/Problems-with-formula-for-creating-cumulative-counts-for-a-Task/m-p/3374...

Ashish_Mathur
2 years ago
Hi,

PBI file attached.

Running total.pbix66 KB

Super User

2 years ago

Hi,

PBI file attached.

Hope this helps.

Running total.pbix50 KB

Anonymous
Not applicable
2 years ago
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?
- lbendlin
  Super User
  2 years ago
  Please provide sample data that fully covers your issue.
  Please show the expected outcome based on the sample data you provided.
- Ashish_Mathur
  Super User
  2 years ago
  What 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.
  - Anonymous
    Not applicable
    2 years ago
    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.

Related content