Difference calculation between dates

[Lorraine88-Siri]

Good day,

Can someone help me with the following:

Have two Excel files in which one states: termination date and the other one: hiring date.

This is used in a chart to show the number of hires and leavers per month in year X.

Now, I like to see the net growth = number of hires minus (-) number of leavers.

How does this work?

[amitchandak · Accepted solution]

@Lorraine88-Siri , You can join the two dates from two tables with a common date table. and you can plot the trend together using common date table.

In case of termination date measure check for non blank

calculate(countrrows(Terminations), not(isblank(Terminations[date]))

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Single table example

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

userealtionship is not needed if they are from two tables and join is active