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.

TrentSP's avatar
TrentSP
Frequent Visitor
6 years ago

Thank you to everyone who replied, the issue is resolved on my end now! The reason why the solutions weren't working for me at first was because of an issue with how I was linking the "Calendar" table to the "Data" table. But this is now fixed and the results look great!

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

You are welcome.