Week over Week Average Sales calculation

[Anonymous]

Hi, I am new to Power BI. I have a scenario where I need to calculate the average sales for the past 13 W and display it in a pivot table. I have attached a sample data where I have highlighted calculation for FW27. Can someone help me how can I achieve the same using Matrix in Power BI.

I want to do this using Live Connection that is the challenge since it has many limitations.

Can someone help it is little urgent.

[v-yuezhe-msft]

@Anonymous,

Could you please share sample data of your original table? You can check the DAX below in the following similar thread about how to calculate week over week average .

http://community.powerbi.com/t5/Desktop/Moving-average-Value-in-weeks/td-p/110652

Regards,
Lydia