Forum Discussion

Chris_68's avatar
Chris_68
Icon for Helper I rankHelper I
1 year ago
Solved

Filtered table

HI Everyone,   I need help to create a table with that take in one value per employee and adds it up as a total number of hours. As an example from the Clocked_hours table, for SO No RO0000021, I w...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi Chris_68 
    Thank you for participating in the Microsoft Fabric Community Forum.
     

    Regarding your question about aggregating actual hours (Act Hrs) per employee for each SO No, I have created a sample .pbix file that demonstrates a solution meets to your specifications.
     

    To help you review the logic ,I’ve attached a screenshot showing the resulting summary table as well as .PBIX file. Please review both the file and the screenshot at your convenience, and let me know if this approach meets your needs or if any further adjustments are required.


    Thank you for being part of Fabric Community Forum.

    Regards,
    Karpurapu D,
    Microsoft Fabric Community Support Team.

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi Chris_68 

We have not yet received a response from you regarding your query if you find the response helpful, kindly mark it as the accepted solution and provide kudos, as this will aid other members with similar queries.

 

Thank You.

  • Chris_68's avatar
    Chris_68
    Icon for Helper I rankHelper I
    1 year ago

    My sincere apology for the late response.

     

    Thank you very much