Forum Discussion
Employees headcount
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.
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!
Hi, Anonymous
Have you tried the funtion of "userelationship" when you need use an inactive relationship?
Here is a simple sample.
Hope it will help you.
Best Regards,
Community Support Team _ EasonYes, I have tried that too, nothing worked
