Forum Discussion
Syncing Two Date Columns Through Visual
Anonymous , I have taken that file. It seems like the file, I shared on the blog with some modification.
Anyways. I added hired count and termination count to the table now when you will drill, both measures will force the data to be visible.
Please find the attached file after signature.
Anonymous , not very clear.
You have :
Terminated Employees = CALCULATE(COUNT(Employee[Employee Id ]),USERELATIONSHIP(Employee[End Date],'Date'[Date]),not(ISBLANK(Employee[End Date])))
Hired Employee = CALCULATE(COUNT(Employee[Employee Id ]),USERELATIONSHIP(Employee[Start Date],'Date'[Date]) )
if required you can add these two.
Waterfall you are plotting current employee, which taking care of both Hire and Termination
Hi amitchandak to clarify, yes I used the Hiring and Terminating columns. Subtracted the two calculations to receive what I want on my visual (can get a better understanding in my onedrive link). If you click on the waterfall visual for a specific month, you will only see employees who had been hired that month in my table visual. For example, 2019 in the waterfall shows we had lost one employee overall that month, but when you click on that year, you see the two employees who had joined that month in my table visual (meaning three left that year). How can I see both the employees who joined and left the company in 2019 in my table? I can't connect both to the Date table because I can only have one relationship. You mentioned creating a duplicate Date table earlier? But I can't picture how that would work.
Anonymous , I have taken that file. It seems like the file, I shared on the blog with some modification.
Anyways. I added hired count and termination count to the table now when you will drill, both measures will force the data to be visible.
Please find the attached file after signature.
Thank you so much, amitchandak!!! This solution seems to work!