Forum Discussion
swisdom
Helper I
Helper IGet rolling average of a Measure
I have two datasets, a series of Returns and a series of Shipments. I have a measure calculating the monthly Return Rate over the running total of shipments. I would like to create another measure wh...
aj1973
Community Champion
Community ChampionHi swisdom
In your date table add a column for Year Month
in your measure replace Date by Year Month
Replace the fields Calendar Year and Month by Year Month
Result
swisdomHelper I
Helper ISo weird I did exactly that and I'm still getting the same results? Can you take a look at my file below and double check? I see that you got the correct results in your version so I'm not sure what I did wrong.
- aj1973
In your measure change these 2
Also don't forget to render the column Year Month to Date format
Let me know otherwise I will send you the file.
- swisdom
That did it, thank you so much!
- aj1973
swisdom Welcome, eventhough I thought Ashish_Mathur solution was more close to what you were looking for.
- parry2k
Super User
Well done Ashish_Mathur 👍
- Ashish_Mathur
Thank you parry2k
