Forum Discussion
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 could I perform such a measure? I have the dates in the sales table and in an extra calendar table.
Thanks a lot.
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
1 Reply
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