Forum Discussion

kangkopi15's avatar
kangkopi15
Helper I
2 years ago
Solved

Weekly total utilization by user

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

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      kangkopi15
      Helper I

      hello Adam Anonymous please confirm, are you able to open the file?

       

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