Forum Discussion
Need Rolling Average But Quick Measure Not Working
Hi everyone, My team is trying to calculate a rolling average of quarterly numbers which will be used to calculate projections for upcoming quarters. I've tried using the Rolling Average quick m...
your visual has an unfortunate date hierarchy. You are calculating by quarter but your visual is locked to year. Throw that hierarchy away by declaring your own dates table in the data model.
Thanks for the answer, but I've already done that in the examples posted above, I just didn't show it. If I drill down one level in the line chart, the Goal and Actual lines correctly show numbers by quarter, but the calculated values ("actual rolling average") don't appear correctly. See the image below