Uploaded February 2025 | Updated September 2026, 2 weeks ago
👀 CLICK MORE... for links and overview
Yep there's more ➡️
Have you ever struggled with dynamically removing rows above a specific value in Power Query? After using Power Query for over a decade, I just been shown this incredibly simple trick that blew my mind! Instead of hardcoding row numbers, this method allows you to automatically remove all rows above a specified value—like a column header—without worrying about future changes in the dataset.
In this video, I walk you through the process step by step, using the Table.Skip function in a way you probably haven’t seen before. This trick leverages a dynamic condition that skips rows until a specific word (e.g., "Name") appears. It’s an absolute gem for cleaning data efficiently. If you're working with messy datasets, this tip will save you time and frustration.
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
👀 CLICK MORE... for links and overview
Yep there's more ➡️
Have you ever struggled with dynamically removing rows above a specific value in Power Query? After using Power Query for over a decade, I just been shown this incredibly simple trick that blew my mind! Instead of hardcoding row numbers, this method allows you to automatically remove all rows above a specified value—like a column header—without worrying about future changes in the dataset.
In this video, I walk you through the process step by step, using the Table.Skip function in a way you probably haven’t seen before. This trick leverages a dynamic condition that skips rows until a specific word (e.g., "Name") appears. It’s an absolute gem for cleaning data efficiently. If you're working with messy datasets, this tip will save you time and frustration.
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
wyn.bio.link
