Forum Discussion
Raul
Post Patron
Post PatronRunning 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])
Greg_Deckler
Community Champion
Community ChampionIn 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])
RaulPost Patron
Post PatronGreat!!! It works perfectly.
Thank you very much Greg_Deckler
- Greg_Deckler
Happy to help! :)