Average Week Sales by Customer & Product - DAX

[matratus34]

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?

 

[Matt Allington]

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.