Forum Discussion
Difference calculation between dates
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?
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]))
Single table example
userealtionship is not needed if they are from two tables and join is active
1 Reply
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]))
Single table example
userealtionship is not needed if they are from two tables and join is active