Weekly total utilization by user

[kangkopi15]

Dear Experts,

Actually, I have an unsolved issue in my prev post.
https://community.fabric.microsoft.com/t5/Desktop/Weekly-visualization/m-p/3950664#M1264793 
I am trying to make another approach, how can I create a new table using the below reference?

My goal is still the same, I need the utilisation filter to apply to the user's weekly total utilisation instead of the user's activity

Thank you

[kangkopi15 · Accepted solution]

I managed to solve this by duplicating the table and running the group by in power-query.

[v-kongfanf-msft]

Hi @kangkopi15 ,

Can't access the pbix file you provided in another link. Please re-share and I will get back to you as soon as possible.

Best Regards,
Adamk Kong

[kangkopi15]

hello Adam @v-kongfanf-msft please confirm, are you able to open the file?

[kangkopi15]

Hi @v-kongfanf-msft apology, please have a try again.