Forum Discussion
Accumulated Values in a bar chart
Hi miikasa
Could you try:
Running total =
Calculate(
[SalesIndex], Calendar[Date] <= Max(Calendar[Date]) --Filter to less than the current max
, Year(Calendar[Date]) = Year(Max(Calendar[Date])) --keep in the same year
)
Super UserHi miikasa
Have you tried the TotalYTD function?
Hi SamWiseOwl,
Thank you for suggestion.
Sorry, I didn't explain clearly.
What I really need is to add a new category in the x-axis and show the accumulated measure. Now when I try to add, it just shows the values by month. Do you have any suggestion on how to do it?
Thank you again.
- SamWiseOwl
Hi miikasa
Could you make a mock up of what you have and what you want please 🙂
Hi SamWiseOwl.
Sure!This is what I have:
And this is what I want:
The x-axis data I built with this formula:
Calendar = CALENDAR(DATE(2022,01,01),TODAY())
And the y-axis I built with this measure:
SalesIndex =DIVIDE([SalesAmount],[AverageCurrentMonthPreviousMonth],0)Appreciate your help. 😊- SamWiseOwl
Hi miikasa
Could you try:
Running total =
Calculate(
[SalesIndex], Calendar[Date] <= Max(Calendar[Date]) --Filter to less than the current max
, Year(Calendar[Date]) = Year(Max(Calendar[Date])) --keep in the same year
)