Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calculate Active Employees with only 1 Date Column

Hello,   I am trying to calculate for the total number of Active employees and YoY growth.   The challenge I am facing is that my data is not commonly arranged arranged as I am using just 1 date ...
Need Help
Tips and Tricks
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    Hi Anonymous ,

     

    Thank you for the detailed explanation.

    Based on sample data  I have implemented the logic accordingly and uploaded the PBIX file for your review. Kindly take a moment to review it and let us know your feedback.

    If you're still facing any challenges, please feel free to reach out we'll be happy to assist you further.

    Looking forward to your response.

     

    Best regards,
    LakshmiNarayana

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

Hi Anonymous ,

 

Thank you for the detailed explanation.

Based on sample data  I have implemented the logic accordingly and uploaded the PBIX file for your review. Kindly take a moment to review it and let us know your feedback.

If you're still facing any challenges, please feel free to reach out we'll be happy to assist you further.

Looking forward to your response.

 

Best regards,
LakshmiNarayana

Anonymous's avatar
Anonymous
Not applicable
1 year ago

v-lgarikapat , This worked perfectly. Thank you!

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

    Hi Anonymous ,

    You're very welcome! I'm glad it worked out perfectly

     

    Best Regards,

    Lakshmi.