Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Rolling 12 Month Calculation Issue

I have been through many of the top answers to this type of issue and still can't seem to come to a solution.   When I attempt to calculate a Rolling 12 Month Sum of a single fields, I either get t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I've gone ahead and created a calendar table according to the method shown in the link you provided and related the Date field from the calendar to the ProcessMonth field from my data table.

 

I have also replicated the measure you have shown as well and it looks like it is still restricted to a single month.

 

Side note: I have a Process Month and a Process Date field in my data table (process month is simply the end of month of the process date)

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
6 years ago

Hi Anonymous ,

 

Would you please inform us more detailed information( your  data(by OneDrive for Business)) if possible? Then we will help you more correctly.

 

Please do mask sensitive data before uploading.

 

Thanks for your understanding and support.

 

Best Regards,

Dedmon Dai