Forum Discussion
AdministratorAverage calculation grouped by project
Super Useryour expected outcome doesn't seem to match the sample data. Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Syndicate_AdminHello, thanks for responding.
Below I send sample of the database:
The expected result would look something like this:
And these avg Time values come out of in this case the sum of the hours per activity per project and then the average of all the projects selected according to the filters, like this:
I hope you can help me and I remain attentive in case additional information is required
- lbendlin
Sorry, I cannot work with screenshots. Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- Syndicate_Admin
Hello, I apologize to me, I did not know how to upload a file with the information. Then send link from Wetranfer where I could find a sample of the database along with the expected solution