Forum Discussion
Solved
Accumulated Values in a bar chart
Hi guys, I have this measure which is linked to a calendar table: SalesIndex = DIVIDE( [SalesAmount], [AverageCurrentMonthPreviousMonth], 0 ) Calendar = CALENDAR(DAT...
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
)
SamWiseOwl
Super User
Super UserHi 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
)