Create a matrix with total minutes of work

[mtrevisiol]

Hi everyone.

I've got a table which shows the total minutes of work for each user of a company:

The column Users contains the list of workers that worked together in a certain timeframe.

If more than one worker is involved in a certain operation, the row containing TimeStart and TimeStop is repeated one time for each worker (see rows 1-2-3 and 7-8). 

My intent is to produce a kind of matrix to show the total amount of work for each worker together with all the other ones, something like this:

On the diagonal, instead, there is the sum of the minutes worked "singularly" by each worker. 

Here is a link to the PBIX file: https://www.dropbox.com/s/99kbjo7f0ierb6i/UsersJobs.pbix?dl=0
I hope it'all clear. Thanks for the help.

[V-lianl-msft]

Hi @mtrevisiol ,

Unfortunately, I tried. It's hard for me to get the result you expect.

For single user and user groups, it is difficult to obtain the contents of large-level groups from small-level groups and judge whether small-level items are in the same group

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.