Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to get the average of the count of [Staff ID] per quarter and I was hoping someone can help me.
Please check the formulas on the right side to maybe have a better understanding of what I am trying to achieve.
So, I am trying to create a formula that takes into account all [Staff ID] MTD and divide it by the Max number of [Month no.]. Of course, I am open to any other approach that might give me the same results.
Thank you
Solved! Go to Solution.
You can use the following formula:
Measure = CALCULATE ( COUNT ( 'Table'[Staff ID] ), FILTER ( All('Table'), 'Table'[Quarter] <= MAX ( 'Table'[Quarter] ) ) ) / MAX('Table'[Month No])
Workspace on this link.
That worked great. Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |