Forum Discussion
Human Resource Sample PBIX
Good Monring All
I am just taking a look at the 'Human Resource Sample PBIX' available online.
Can anyone shed anylight on what the Date column is? this may be a silly question
https://docs.microsoft.com/en-us/power-bi/create-reports/sample-human-resources
Snip below.
Hi Anonymous ，
The calculated column [isNewHire] mentioned in your snipshot is used to determine whether the current employee is new hired, where the [Date] field is the date of each day (record date), and if the year and month of the HireDate are the same as the record date, then the employee is determined to be a new hire. If an employee leaves on 2021/8/30, the employee's information will only be recorded in the Employee table before 2021/8/30. Therefore, when calculating whether an employee is a new hire, it does not take into account whether the date of departure is empty or less than the record date...
Best Regards
3 Replies
Hi Anonymous ，
The calculated column [isNewHire] mentioned in your snipshot is used to determine whether the current employee is new hired, where the [Date] field is the date of each day (record date), and if the year and month of the HireDate are the same as the record date, then the employee is determined to be a new hire. If an employee leaves on 2021/8/30, the employee's information will only be recorded in the Employee table before 2021/8/30. Therefore, when calculating whether an employee is a new hire, it does not take into account whether the date of departure is empty or less than the record date...
Best Regards