Building table of Average Monthly Sales

[Anonymous]

Hi

I'm trying to build a table that contains the average monthly sales PER Customer.

Then I want to see the trend of monthly sales compared to the average sales Year To Date per customer. This will help me to see the trend of customer orders.

Thanks in advance

Customer	Jan-21	Feb-21	Apr-21	May-21	Jun-21	Monthly Average Sales Year to Date (Per Customer)
Customer A
Customer B
Customer C
Customer D

I tried to use the following, but this gives me the average sales per day and NOT the average sales per month for each customer.

Tot. Value Transactions = sum(OrderData[OrderValue])

Average_Per_Customer = AVERAGEX(ALLEXCEPT(OrderData,OrderData[Customer Name]) , [Tot. Value Transactions])

I've attached sample data file. NOTE: On any day you can get several transactions for same customer. For simplicity, I just put one transaction per day.

Link to Sample Data 

[amitchandak · Accepted solution]

@Anonymous , hope you have month year, Try like 

Average_Per_Customer = calculate(AVERAGEX(values(Table[Month Year]), [Tot. Value Transactions]),ALLEXCEPT(OrderData,OrderData[Customer Name]))