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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Based on that data that you have shared, show the expected result in Table format.  Once we get the correct numbers in the Table, we can create a line chart.  Also, in the PBI file that you share, ensure that you have a Calendar table with a week number column. 

YweiB's avatar
YweiB
Frequent Visitor
3 years ago

Hi Ahish,

 

Could you give me some idea in how to visuliaze moving average in two conseuctive years like 2022-2023. and 2023 moving average is related to data in end of 2022. 

I already created the week rank for those data, I also have the week number for each data.

I want to put 2022 moving avergae line and 2023 moving average line to compare the performance of two years.  something like this chart. but the number can correctly reflect the moving average.

 

Thank you so much for your time to help me!