Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.