Forum Discussion
Saad_Hanif456
Helper I
Helper ILeavers
Dear Experts, I am stuck in the challenging situation. Have a payroll data for all the months and years in one sheet but there is not any column Active / Nonactive staff. How can i identify/...
Simple enough, WINDOW functions do the trick more easily than Time Intelligence functions in such a scenario.
AntrikshSharma
Community Champion
Community ChampionSaad_Hanif456 If you don't know who left and there is no column indicating that then how can we/DAX identify who left? Instead of spending time on this go back to your client/DBA and push them to add a column for Exit date, this is a very basic information, they must maintain it.
Saad_Hanif456AntrikshSharmaThank you for the response, cannot we find with the employee id since it is unique for every employees?