Average per month

[RobbeVL]

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 first row in the screenshot:

(taking months in slicer into account, or starting from March in this case)

22+19+19+19+18+16 = 113/ 6 = 18.83

I hope you can help me out!

[v-chuncz-msft]

@RobbeVL,

You may consider using UNION Function to add a calculated table first.

[Anonymous]

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