Forum Discussion
RobbeVL
Impactful Individual
Impactful IndividualAverage 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.
- RobbeVL
Anonymous
I cant seem to get it to work :/
Anyone able to help in this example file below?
https://www.dropbox.com/s/47qbl4f5vquzw3o/DatamodelParcify_CSV_RobbeUpload.pbix?dl=0
