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])
Great!!! It works perfectly.
Thank you very much Greg_Deckler
Happy to help! :)