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

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

Link to file 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
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.