Forum Discussion

YweiB's avatar
YweiB
Frequent Visitor
3 years ago

Need Help in Visualization for 13 week moving average

Hi all,   Currently I have a list of sales data from 1/7/2019 to 6/19/2023. I used window function to calculate the rolling 13 week average for this sales data. Here is the function of Rolling ave...
Need Help
Tips and Tricks
YweiB's avatar
YweiB
Frequent Visitor
3 years ago

Here is the sample data in pbi. 

Sample Data 
Could you help with me in this? Appreaciate your time and help in advance!

 

Best.

YB

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

That take me to a sign-in page.  Also, in the Excel file that you share, show the expected result.

  • YweiB's avatar
    YweiB
    Frequent Visitor
    3 years ago

    So sorry for the confusion.

    Here is the google drive link, I uploaded the pbi file and excel data in here.

    Link to sample data 

    The expected chart is in pbi file.

     

    Thank you so much! Appreciate for your time!

     

    YB

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      In your post dated June 23, you showed a Date column but in the Excel file that you have shared, there is no date column and therefore i am confused.  I will just share the DAX pattern with you.

      1. Create a Calendar Table with
      2. Create a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table
      3. To your visual, drag Date to the X-axis
      4. Write this measure

      13 weeks moving average = averagex(calculatetable(values(calendar[date]),datesbetween(calendar[date],min(calendar[date])-84,max(calendar[date]))),[Total sales])

      Hope this helps.