Forum Discussion

Darwinm's avatar
Darwinm
Frequent Visitor
4 years ago
Solved

3 month rolling calculation

Hi folks,    I am trying to calculate 3 month rolling rate and have been struggling to get desired results. I have perfomed the analysis in Excel before moving to Power BI and am attching a snapsho...
Need Help
  • Darwinm's avatar
    Darwinm
    4 years ago

    Solution:
    3 month rolling = CALCULATE(
    AVERAGEX(VALUES('Calendar'[Date (bins)]),[Sales]),
    DATESINPERIOD('Calendar'[Date (bins)],MAX('Calendar'[Date (bins)]),-3,MONTH)
    )

Darwinm's avatar
Darwinm
Frequent Visitor
4 years ago

I figured out the calculation. Had to work around a bit of hussle but got the measure right. 🙂

  • ribisht17's avatar
    ribisht17
    Super User
    4 years ago

    Wow!You can share the solution here and mark the post as solution