Forum Discussion
bhmiller89
Helper V
Helper VRolling 90 Day Avg
I've combed the forums and have tried to replicate what others have done but with no luck. I need to show actual dollars won over a rolling 90 day average. I wrote a measure to show Today's date ...
bhmiller89Helper V
Helper VHi v-huizhn-msft,
This makes sense. However, I don't need the ability to look at rolling totals on historic dates, only in real time. So if I look at the Dashboard this morning with refreshed data, I would see a rolling total 90 days before today, and then when I check tomorrow it will be 90 days from tomorrow.
I'm really bad at using "date" tables and was trying to avoid that if possible!
v-huizhn-msft
Microsoft Employee
Microsoft EmployeeHi bhmiller89,
You'd better create a slicer to filter the date, please see the following screenshot, when you select the 2016/5/1, it will return the sum total of last 90 days from 2016/5/1.
Best Regards,
Angelia