Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Status changes - active/inactive employee record

Desperately need the amazing support of this group to figure this one out. I am trying to determine the position to date per each employee. Any help would be much appreciated!!   Facts about the da...
Need Help
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
4 years ago

Hi Anonymous ,

 

Replace the following formula, whether the result returned by return has the wrong sign, etc. 

IF (
    COUNTROWS ( VALUES ( EmploymentHistory[Employee] ) ) = 1,
    'Date range: ' & _selectedDateRangeStart & '>>' & _selectedDateRangeEnd & 'Count Rows Employment History: '
        & COUNTROWS ( _EmploymentsBeforeDateRange ) & 'Last role date change: ' & _LastRoleChangeDate & 'Role history: ' & _RoleChangeHistory & 'Last role: ' & _lastRole
)

Also you can determine if the parameters are correct by returning the individual parameters set by return.


If there is still a problem, can you provide the relevant test data (remove sensitive information) and the desired result, I will answer for you as soon as possible.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.