Forum Discussion

PHEstaciMa1's avatar
PHEstaciMa1
Helper II
11 months ago
Solved

Calculating Performance Percentage from 2 Tables with condition

Hi Everyone, I need help in creating a performance compliance percentage table from 2 different tables. Data Table Input 1 is the actual performance of employee who created a tag on a monthly basis. Data Table Input 2 is the Target Tag Creation per Employee per Month. 

 

The expected output table should provide me compliance percentage per month. Now, there is a condition here, the target tag creation per employee per month is only 1 Tag per Month per Employee, regardless if the employee created 2,3,4, and so on, it will only count as "1".  I have attached an excel file for better understanding and data manipulation. Google Drive 

 

 

Jihwan_Kim 

Need Help
Show and Tell
  • v-achippa's avatar
    v-achippa
    11 months ago

    Hi PHEstaciMa1,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Ashish_Mathur and danextian for the prompt response. 

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

5 Replies

  • v-achippa's avatar
    v-achippa
    Community Support
    11 months ago

    Hi PHEstaciMa1,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you Ashish_Mathur and danextian for the prompt response. 

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      11 months ago

      Hi @PHEstaciMa1,

       

      We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

      • v-achippa's avatar
        v-achippa
        Community Support
        10 months ago

        Hi @PHEstaciMa1,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa