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 guys,
My question is preety straight forward, but I can't get this done.
I want to calculate an weighted average on a table with number of days as below:
Country | HC | Working Days |
Brazil | 139 | 22,0 |
USA | 12 | 19,0 |
Total | 151 | 21,76 |
So basically I would need to average the number of days worked in a month for USA and Brazil having the Headcount as a paramenter, the results should be as the one in the table.
Thanks!
Solved! Go to Solution.
Can someone please help me?
More or less the first google result, but anyway...
Thanks anyway!
To make it easier to understand, the mathematical formula would be ((Working days Brazil * HC Brazil)+(Working days USA * HC USA)) / (HC Brazil + HC USA)
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |