Forum Discussion

TrentSP's avatar
TrentSP
Frequent Visitor
6 years ago
Solved

Rolling Weighted Average

I'm looking for help in trying to calculate a rolling weighted average in my dataset. Below is an example of the data I'm working with:   Category Year X Y 1-Year X/Y 2-Year X/Y A 2000 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

OK, walk me through what is supposed to happen in order to get your desired numbers. So how is that 53% supposed to be calculated? In just plain language.