DAX query - Looking up (v-lookup) in the same table

[Sindrin]

Hi All,

Hoping can get some input from the DAX experts here.

I have a table imported via power query.

It has 2 columns

1. Employee ID - this contains a list of employee IDs
2. 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

 

[alansidman]

show us some sample data using XL2BB so that we can test our solutions. Do not post a picture as we can not manipulate data in a picture.