- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You may consider using UNION Function to add a calculated table first.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-11-2024 04:04 AM | |||
09-09-2024 01:56 PM | |||
09-25-2024 05:41 AM | |||
07-28-2024 04:42 PM | |||
08-15-2024 08:50 PM |
User | Count |
---|---|
128 | |
81 | |
59 | |
57 | |
44 |
User | Count |
---|---|
184 | |
111 | |
82 | |
66 | |
52 |