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!

     

lbendlin's avatar
lbendlin
Super User
1 year ago

You can use Gantt charts or Deneb for that if you want a graphical solution.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523