Forum Discussion
Return Previous Date
Hello, I know there is documentation out there, but maybe there’s a better answer. I want to return the previous date of and ID. I have a PatientID, Admit Date. I want to create a new column called...
Can we derrive this in Power Query?
AilleryO
Memorable Member
Memorable MemberHi,
Certainly yes, maybe using LastN function or else, but I must confess I do not have a solution ready made for you.
This might guide you :
https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group
Let us know if you found your solution