cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

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?

Thanks in advance for you help!

4 REPLIES 4
Memorable Member

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

The above answer is for Power BI..

Mark it as a solution if it solves.

Kudos are nice too

Helper I

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])....

Super User

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

Helper I

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

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors