Forum Discussion
Solved
Running total
Hello everybody, I have a CALENDAR table in my data model. I have too two more tables: WAREHOUSES and TARGETS: ID WAREHOUSE A Warehouse1 B Warehouse2 C Warehouse3 YEAR WA...
In looking at your data layout and calculation, I would create a MONTH column in your Calendar table and do something like:
Measure = MonthTarget * AVERAGE(Calendar[Month])
Have you tried the Running Total quick measure?
Yes, but the result is the same value of the month target for every mont, like this:
Month Target RunningTotal January $ 416,67 $ 416,67 February $ 833,34 $ 416,67 March $ 1.250,00 $ 416,67 Can you post that formula?
RunningTotal =
CALCULATE(
[MonthTarget];
FILTER(
ALLSELECTED('Calendar'[Month]);
ISONORAFTER('Calendar'[Month]; MAX('Calendar'[Month]); DESC)
)
)
