Find previous record - a tricky Power Query Example

This video demonstrates how you can pre-shape data based on the previous record in a data set. It is part of my online Power Query training. Read more at xbi.com.au/pqt

[@gils33]

It's been more than a day that I was trying everything I had in mind to do something quit similar... When I saw your explanation it was like a revelation... Of course, 2 indexes to help me join to itself some data ! It's so simple but so out-of-the-box at the same time !

[@Wyd4]

the 2 index columns and the merge query. I dont think I have ever been so disappointed in myself for not thinking such a logical solution. Thank you sir!! The previous solution I had ate time and memory.

[@guices]

I'm so happy that I found this video, thank you so much! You just saved my life!

[@elizabethtachjian8151]

Your videos and blogs are clear and so easy to follow. Thank you! I will check your site for intermediate Power Query courses.

[@ramanavaranasi683]

Hi Elizabeth, you can find the preview videos and details of Power Query Online Training by Matt Allington here. exceleratorbi.com.au/power-query-online-training/

[@ThereforeIAm0]

Very helpful, thanks! Chatgpt couldn't solve this for me after multiple attempts. Found the link to your video on the original query.

[@maantunez]

I think this video has the solution I was looking for. Many thanks for such clear explanation.

[@boudewijnmulders1920]

Finally I found the PowerQuery equivalent for Excel's VLOOKUP with approximate match! Have been looking for this for days! So simple once you see the solution! B R I L L I A N T ! ! ! !

[@phsycomanthis101080]

Hi, I just wanna say thank you for sharing this! very nice tips!

[@louukya]

This is awesome, you made it simple. - Thank you

[@retamapark]

Thanks, Matt! Very interesting technique.

[@SamiElzaim]

This video was of great help. Many thanks and keep on the good stuff.

[@m.raedallulu4166]

That was smart, sir. Thank you!

[@joanhauff2479]

Excellent!

[@mffarooqpk]

Excellent tutorial. I am facing a problem, can we use this technique with grouped data with multiple columns. Thank you for sharing this valuable information with us

[@scoorpioo1234]

genious! thank you, you saved me a lot of time with this trick :)

[@Oprimaita]

Just brilliant ! Thanks a lot !

[@veeek8]

You're a genius thank you!

[@janwillemvanholst]

Brilliant! Thanks.

[@tapendarkondapuram7505]

Hi, state begin and state end columns are their in the data.How can i calculate Runtime and downtime .State begin and state end columns representation is down time of a machine. can you help me how can i calculate runtime based on date selection.(Each day having 3 shifts(8hrs*3=24 hrs))

[@19rgc91]

Thank you!

[@elizabethtachjian8151]

Hi, Is there a way to only pick up previous record only for the same customer. For example row 5 to be blank since it was XYZ first transaction.

[@jamescarey6162]

Solved my problem. Thank you!

[@joanhauff6541]

Fabulous!

[@johnjenkins954]

What if there is a third forth fifth ticket within 7 days of the first? how would I return the first case if 10 cases came in within the 7 days.

[@oswevega2939]

very good trick. thanks so much. Excelerator haha nice nick