Problem with datas

Hello to all. Would greatly appreciate your help with the following matter.

I have two tables: 

1. Dates - 1.01.2016 to today (i.e. March 11, 2023)

2. Employees - list of employees with hiring and termination dates.

These two tables have inactive relationships dates - hiring date, dates - termination date

For headcount calculation, I use max('Date'[Date]).

For some reason max(dates) changes depending on the employee, however, should be March 11, 2023 for all employees:

What could be the reason?

Tamila