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
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




