Forum Discussion
Solved
Getting Data From Previous Row Based On Two Criteria
I have have the table 'Data' with the fields 'employee ID', 'rotation number', and 'location' with each employee ID appearing three times with rotation number increasing each time and a location code...
HotChilli wrote:Is the last value in 'last location' a mistake? Should it be uvwx?
Yes, that was a mistake. I've fixed it now.
HotChilli wrote:If so, try adding a column
The column kinda works, but it is only pulling the entry for rotation #2 and then displaying it for all rows after the first:
+---------------+-------------------+------------+-----------------+ | employee ID | rotation number | location | last location | +---------------+-------------------+------------+-----------------+
1001 1 abcde xxxxx 1001 2 fghij abcde 1001 3 klmno abcde 1002 1 pqrst xxxxx 1002 2 uvwx pqrst 1002 3 yzab pqrst
Do you want to link your pbix here and i'll have a look at it?
