Forum Discussion

sbstern's avatar
sbstern
Advocate II
8 years ago

Rolling Average Quick Measure Incorrectly Calculating the Future

This is the first time I've tried using the new Rolling Average Quick Measure and I'm out of ideas as to what's wrong. I'm trying to get a 12-month rolling average of our revenue/customer. The blue l...
Data Modeling
Reports
kubo's avatar
kubo
Regular Visitor
8 years ago

I solved this isue by filtering out the future values with a following measure

 

IsRecord = IF(max(Table1[value])<>BLANK();1)

Then set a filter only for values where IsRecord is not blank. Table1[value] is your base value in rolling average. Enjoy.