Forum Discussion
AdministratorAverage calculation grouped by project
AdministratorHello, 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
Super UserSorry, 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
- Ashish_Mathur
- Syndicate_Admin
Thank you very much, that was what I needed. Just one more question, there is some way to calculate the sum of those averages obtained like this:
That large total can be presented on a card
