In this video, Avi Singh explains how to perform a "self-merge" in Power Query in Power BI. A self-merge is when you need to merge a table with itself, typically when the information you need is present in the same table but on different rows. Avi demonstrates the steps to achieve this technique, which can be invaluable in certain scenarios. If you're interested in learning more about Power BI and data modeling, Avi offers a Power BI training program that you can check out. You can also reach out to him on LinkedIn for free help.
Login now to access my digest by 365.Training