Forum Discussion

Helper I

4 years ago

Solved

Get 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...

Need Help

aj1973
4 years ago
Hi 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
aj1973
4 years ago
swisdom
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.