Summarize values of certain data

[mafioso]

Hi, 

I want to summarize the hours of certain employees. For example i have currently 4 rows with employees + hours and want to summarize them to a Team. So in Power BI there should be the Teamname instead of the employees. Can I use a group by or something like that? 

1. Milner      
2. Cook
3. Joshua
4. Williams

I want to give them a teamname and summarize their working hours.

[Anonymous · Accepted solution]

Hi @mafioso

Can you give the team name to employees in the dataset itself (using query editor or bring the team name from datasource itself)?

So your final dataset is something like this-

Team      Employee     Hours

A             Milner           5

A             Cook             2

B             Joshua           3

B             Williams         5

Now you can use Matrix visual to show Team wise summarized hours.

And the drilled down view will look like below-

Hope this helps!