Hi All,
Hoping can get some input from the DAX experts here.
I have a table imported via power query.
It has 2 columns
Note - The same employee ID can appear twice in the table e.g. having a current month row and a last month row
How can I lookup those employee IDs (in previous month) that are no longer in the current month?
I want to add a column in the same table to say those employee IDs in previous month that are no longer in current month to be flagged with "Leaver", the rest to remain null/blank.
Is this possible?
Many thanks in advance,
Prinz
Hoping can get some input from the DAX experts here.
I have a table imported via power query.
It has 2 columns
- Employee ID - this contains a list of employee IDs
- Month - this contains 'current month' and 'last month' value
Note - The same employee ID can appear twice in the table e.g. having a current month row and a last month row
How can I lookup those employee IDs (in previous month) that are no longer in the current month?
I want to add a column in the same table to say those employee IDs in previous month that are no longer in current month to be flagged with "Leaver", the rest to remain null/blank.
Is this possible?
Many thanks in advance,
Prinz