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

Master SQL Essentials: From Beginner to Pro in Data Analysis and Beyond!

4.0 (0)

12 learners

What you'll learn

Understand the basics of SQL and its application in data analysis
Utilize SQL with tools like Power BI for comprehensive data reporting
Master different types of SQL joins to manipulate and analyze data effectively
Learn how to create and manage a database using MS Access

This course includes

6.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

chandoo chandoo.org power query self join in power query selfjoin powerbi power bi

Full Transcript

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: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx Need Power BI Skills for yourself? Join my Power BI course - https://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

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome