Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |