Forum Discussion
Get last or previous row based on a condition
Hello PBI Community, I have historical employee data that is constantly chaging and would like to get one row per employee. But the condition that I need to meet is: If status for the latest re...
Hi VishalJhaveri,
For 5e Choe either the first or the second record will be correct. The reason is that the Status for 5e Choe is the same (T) for the records.
Because in those scenarios (ID: 5e) either the first or the second can work, I'm not sure what it will simplify the process.
Hope this makes sense.
Thank you so much.
Thanks Vishal!
It is perfect. Really appreciate your help
Hello brother. Anonymous
Glad to know it worked for you.🙂
Can you please mark my answer as solution?
Thank you.
Hello brother. @viviarc
Glad to know it worked for you.
Can you please mark my answer as solution?Thank you.