Time spent on Tasks by each application

Hi nadirS ，

What's your logic of calculation? Would you please explain more about it? Why there is Application1Update in your calculation for John?

For a preliminary understanding of your data, I transform your table 1:

And create a relationship between table1 and table2:

For more deatils, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EQA8W3_qbUlArIIZbtCNiyUB12388jPdu-0kqb4IEZ2EeQ?e=qabI0d

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

Best Regards,

Dedmon Dai