I'm a little stuck and hope you can help? I need to calculate a rolling average of ITIssues over a time series but the time series does not contain a date, just period numbers. My example data is:
The period numbers do not correspond to equal date periods eg period 1 in 2017/18 is not the same date as period 1 in 2018/19. I need to see a rollling average over the periods.
Go to Solution.
I would create a new calculated column that is essentially the numeric equivalent of your Period like:
Then you could use the same basic concept of a rolling average without the date. You should be able to do something like:
Column = SUBSTITUTE([Column1],"/","") * 1
This may also help:
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
Proud to be a Datanaut!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.