cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Agaidar
Helper I
Helper I

How to calculate average sales by different price points, weeks, products and customers?

Hi Team,

 

Hope this one should easy to crack for you coz I'm strugling to find the answer all this week...

 

If there is any way to calculate average (of sales) filtering by multiple column?

 

Capture.JPG

 

Thanks in advance for you help!

 

 
 
4 REPLIES 4
VasTg
Memorable Member
Memorable Member

@Agaidar 

 

Create a table visual with Product,customer,week,price and Average of Units.

 

image.png

 

The above answer is for Power BI..

 

Mark it as a solution if it solves.

Kudos are nice too

Connect on LinkedIn

Thanks for short reply but it's not what I'm looking fo

 

If I do simple average it will calulate average for all rows that I have while I need average by customer, product, week and price...hope it makes sense

 

something like: calculate ( average [sales], filter [price], [customer], [week], [product])....

 

 

 

You can add Slicers for those, That will change.  Can you provide specific examples what you need

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

I use them now but I have more than 30,000 skus in forecast modeling.

 

So, this is my case:

 

1. System generates forecast at sku/price point level, but sometimes I have to do adjust forecast manually

2. Price point owned by different team and if they update price and I dont have system forecast for this week/customer it's stays as it is.

 

Example: I know that average sales at 5$ for product B at Customer A should be 5000 units for the next 3 weeks but at week 4 I have forecast at 2000 units (this is mistake) -> So, I just I need a raking table with ratio where I can sort biggest outliers I highligh my issues rather than going and check every single customer/product

 

I was thinkig that average by categories will help, coz then I can compare my forecast for particular week vs what average (or max) should....but I need average by price points, customer and sku

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.