Forum Discussion
Solved
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 ...
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
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