Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Employees headcount

Hello All,    I am working on power bi and I am facing a challenge in calculating total number of employees,  I have seen several articals in which they create inactive relationship between calend...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Actual Relations

     

     

    Left Side actual result, right side by using your DAX measures

     

     

    Hello amitchandak 

    Thankyou for your reply, I have attached 2 images, the first one shows the actual relations which i made and second one shows the results, 

    Results in left table are the actual results and right ones i created by using the dax which you shared.

    Please have a look what I atually want, and do suggest 

    Thanks!

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anonymous , can you share the formula you used. Do these dates have a timestamp. hire number seems off by far at few places.

      Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello amitchandak 

         

        What I did is as I showed my model looks like that, and I used the formula which you shared for inactive relationships and the result comes out to be the one on right hand side.

         

        Employee Table has ID, Start date and End date

        Calendar table has Date, year, month, period

         

        And in my model I have joined calendar table with timesheet table on date basis and 

        Joined timesheet table with employee table on ID basis

        when I make 2 inactive relation with calendar and employee table. Then results comes out to be as I attached earlier.

         Basically timesheet is my transaction table and employee, Workorder, costcentre tables are my fact table.

        All tables are directly joined with timesheet table.

         

        Sorry, I can not share the data as its very sensitive. Can you prepare a model and work on it by taking random values.

        Thanks!