Find Missing Numbers in Power Query (with UI Support!)

Discover a UI-focused #PowerQuery solution for this Excel BI challenge: Identifying Continuous Sequences plus all Missing Numbers in between. I'll demonstrate the power of UI support - showcasing that clicking is safer than typing. 😁 Here is the step-by-step process to solve this challenge:
-Shifting down by one row with the help of two Index columns
-Merging the table with itself (Table.NestedJoin)
-Logic in custom column to identify the starting point "From"
-Standard grouping to define the end point "To"
-Custom grouping to identify the missing numbers
-Simply expand with the help of the UI

Compare this UI driven approach to my shorter 4 step solution in the comments.
👉 Choose the approach that best suits your personal preferences and style❗

Watch now and conquer this challenging task!

Here is the link to the Excel BI challenge itself: lnkd.in/eCHcKxbf

#Excel #PowerBI
Like 👍, comment 💬, and share ➦ with fellow data enthusiasts to spread the knowledge!


Ready to become a Power Query master? Join me, Matthias Friedmann, and learn advanced data techniques and solve complex Power Query challenges with ease:
🔔 Subscribe for more expert Power Query tutorials:    / @matthiasfriedmann  
Connect with me on LinkedIn for more insights, updates and tips: www.linkedin.com/in/matthiasfriedmann