Problem with datas

[Tamila]

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

[Anonymous]

@Tamila  Have you tried applying the ALLEXCEPT function to the name column?

[Tamila · Accepted solution]

Thank you for the suggestion, tried it, same problem(

[Anonymous]

@Tamila  can you share the measure you wrote?

[Tamila]

Max data = CALCULATE(MAX('0. Дата'[Date]),ALLEXCEPT('0. Дата','0. Дата'[Date]))

[Tamila]

Sorry, my mistake, here is the correct formula 

Max data = CALCULATE(MAX('0. Дата'[Date]),ALLEXCEPT('3. Employee','3. Employee'[Name]))

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  If data is confidential, anonymise the data first.  Please also show the expected result.