Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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]))
@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]))
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |