Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Average weekly sales

Hello everyone, I have a query. I have a sales table with dates, product code, quantity, location and price, etc. I would like to get a weekly average of the quantity sold for each product. How coul...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Syndicate_Admin , With help from a date table

 

AverageX(Values('Date'[Year Week]), calculate(Sum(Table[Quantity Sold])) )

 

in case you need this week vs last week

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510