Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Thank you for the suggestion, tried it, same problem(
Thank you for the suggestion, tried it, same problem(
Sorry, my mistake, here is the correct formula
Hi,
Share the download link of the PBI file. If data is confidential, anonymise the data first. Please also show the expected result.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |