Average per month

Question

Hi all,&nbsp;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&nbsp;for example taking the first row in the screenshot:&nbsp;(taking months in slicer into account, or starting from March in this case)22+19+19+19+18+16 = 113/ 6 = 18.83&nbsp;I hope you can help me out!&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

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 · Answer

&nbsp;AnonymousI 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

v-chuncz-msft · Answer

RobbeVL,
&nbsp;
You may consider using UNION Function&nbsp;to add a calculated table first.

Forum Discussion

Average per month

3 Replies

Related content

Calculating average 12 month average

Total per month / average per month

Dynamic Average per month Calculation

Average for Month Excluding Current Month

12 Month Rolling average.