Forum Discussion
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...
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)
Anonymous not sure why it is not working, it is hard to say without looking at the data, can you share pbix file (remove sensitive information before sharing) and let's go from there. You can share using one drive/google drive or send it directly to me via email, it is in the signature.