Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

How to dynamically track activity based on start date and end date

Hello and good day. In my current application I have a column tracking employee start date and another tracking employee end date. I want to try and display a graph that shows employee activity on a ...
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    Hi Anonymous ,

    Follow these steps

    Make sure calendar table is correctly mapped with from Employee table

    use DAX measure instead of calculated column

     

    Active Employees =

    CALCULATE(

        COUNTROWS(Employee),

        (ISBLANK(Employee[End Date]) || Employee[End Date] >= MIN('Calendar'[Date]))

    )


    Expected output :




    If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

    If you continue to face issues, feel free to reach out to us for further assistance!

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thank you for the reply I feel like it explains my problem quite well. Nonetheless I managed to already find a solution mostly using this video:
https://www.youtube.com/watch?v=pQ9eSnfAhnc

v-aatheeque's avatar
v-aatheeque
Community Support
1 year ago

Hi Anonymous ,

It looks like your problem has been solved, please mark the helpful reply and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you very much for your kind cooperation!