Forum Discussion
Week over Week Average Sales calculation
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.
1 Reply
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