How to Self-Join Tables in Power Query [Step-by-step Tutorial] @chandoo_
How to Self-Join Tables in Power Query [Step-by-step Tutorial]  @chandoo_
Uploaded August 2025 | Updated November 2026, 10 hours ago
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the "prior weekly rental" and "prior move out date" from rental agreement data with Power Query.

Sample data file: chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx

Need Power BI Skills for yourself?
Join my Power BI course - chandoo.org/wp/power-bi-course

~

A data engineer got divorced. When friends ask her what happened, she replied,
"I left the join because it wasn't the right join." ๐Ÿ˜†

#powerbi #powerquery
How to Self-Join Tables in Power Query [Step-by-step Tutorial]Using WRAPROWS to Reshape Data (NEW Function ๐Ÿคฏ) #excelHow I Use AI To Work Smarter Every Day as a Data AnalystStop making boring column charts in Power BI - Do this instead ๐Ÿ’กHonest review of Excel CoPilot - What it can and cannot do ๐Ÿค–Excel Pivot Tables - Master Data Analysis in just 45 minutes
Chandoo |

How to Self-Join Tables in Power Query [Step-by-step Tutorial]

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER