Average Week Sales by Customer & Product - DAX

matratus34

Board Regular
Joined
Nov 21, 2013
Messages
74
Hi Guys, I'm new to PowerPivor/DAX so just looking for a point in the right direction when it comes to trying to work out my measure for what I'm trying to achieve below.

I've got a table in my data model with total sales by customer and product over 6 separate weeks.

Can you point me in the right direction as to what measure I should be using to be able to calculate the average weekly sales for the whole 6 week period by customer and product that I can pull into my pivot?

Hopefully that makes sense?
 
Last edited:

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Every DAX formula depends on the table structure in your model and the way the data is stored. You really need to share the model design, sample data and expected results.
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top