Forum Discussion
moving monthly average
Okay, I know there are many that have stumbled across this but I don't see any answers here that I can use. My fiscal year starts in April and I need to calculate a 6-month moving average of sales qt...
Well, it is kind of working, but even if I start the month at the first month of the fiscal year, it is still taking all dates available to the data model into account. Please let me know if there is something I may be doing wrong?
Hi sdmikejr,
Can you provide some detail info about this? (e.g. your table' structure, sample data)
Regards,
Xiaoxin Sheng