- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Leavers
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/filter employees ( the entire row of the staff) left till to date by Emp ID which is unique.
Please suggest anyone who have an idea of performing it
Following is the sample data for helping me in this regards.
Payroll Date | Emp ID | Name | Department |
01-10-22 | 10022 | Sajid | Sales |
01-10-22 | 10023 | Imran | Sales |
01-10-22 | 10024 | Ali | Sales |
01-10-22 | 10025 | Abid | Marketing |
01-10-22 | 10026 | Romail | Marketing |
01-10-22 | 10027 | Umar | Finance |
01-11-22 | 10022 | Sajid | Sales |
01-11-22 | 10028 | Rehan | Sales |
01-11-22 | 10024 | Ali | Sales |
01-11-22 | 10025 | Abid | Marketing |
01-11-22 | 10026 | Romail | Marketing |
01-11-22 | 10027 | Umar | Finance |
01-12-22 | 10022 | Sajid | Sales |
01-12-22 | 10028 | Rehan | Sales |
01-12-22 | 10024 | Ali | Sales |
01-12-22 | 10025 | Abid | Marketing |
01-12-22 | 10029 | Kashan | Marketing |
01-12-22 | 10027 | Umar | Finance |
Note: Employees highlighted in the Yellow color is left from the Company in the respective month
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Simple enough, WINDOW functions do the trick more easily than Time Intelligence functions in such a scenario.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Simple enough, WINDOW functions do the trick more easily than Time Intelligence functions in such a scenario.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Saad_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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@AntrikshSharmaThank you for the response, cannot we find with the employee id since it is unique for every employees?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-13-2025 01:03 PM | |||
11-03-2023 06:45 AM | |||
05-29-2023 10:46 AM | |||
02-10-2024 11:00 PM | |||
02-15-2024 11:41 PM |