Forum Discussion

swisdom's avatar
swisdom
Icon for Helper I rankHelper 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's avatar
    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's avatar
    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.

     

swisdom's avatar
swisdom
Icon for Helper I rankHelper I
4 years ago

That did it, thank you so much!

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
4 years ago

swisdom Welcome, eventhough I thought Ashish_Mathur solution was more close to what you were looking for.