Forum Discussion
Average per month
Hi all, Below I added a screenshot of the total amount of orders per users, per month. What I would like to calculate is the average number of orders per month per user for example taking the ...
You could do something like this to get the total amount of orders for selected months:
Calculate(SUM(Table[Orders]), ALLSELECTED(Table[Months]))
This will get you an overall sum of orders for the months selected. Do the same to get the count of orders for all months and divide the two numbers.