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 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
)
