Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
You may consider using UNION Function to add a calculated table first.
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.
@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