Forum Discussion

Venkata1858's avatar
Venkata1858
New Member
4 years ago
Solved

Rolling 5 weeks average

Hi, I'm new to power bi, I need to calculate rolling 5 weeks average for my weekly sales data, I tried in multiple ways but I'm getting wrong output can some one help me please. below is the data I ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Download the PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Download the PBI file from here.

Hope this helps.

  • Venkata1858's avatar
    Venkata1858
    New Member
    4 years ago

    Hi Ashish_Mathur , Thanks a  lot it is working perfect, your response was quicker than escape velocity.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      You are welcome.  Thank you for your kind words.

  • Venkata1858's avatar
    Venkata1858
    New Member
    4 years ago

    @Ashish_Mathur, May I know how this DAX works 

    5 weeks rolling average sales = if(isblank([Sales]),blank(),AVERAGEX(DATESBETWEEN('Calendar'[Date],MIN('Calendar'[Date])-34,Min('Calendar'[Date])),[Sales]))
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      4 years ago

      Please read up on the AVERAGEX() and DATESBETWEEN() functions.  You'll then be able to understand the formula.

      • Venkata1858's avatar
        Venkata1858
        New Member
        4 years ago

        Sure Ashish