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