In this new video, we will explore Power Query to reset row numbers when the value in a column changes. Usually, it is very easy to achieve when you have a column that can help group the rows but when there is no such column available, it becomes a little challenge to achieve the same, and this video will walk through the thought process of how this can be approach and then showcase the solution in Power Query.
The video not only explores the theoretical approach but also provides a step-by-step demonstration of the solution within Power Query. You'll gain insights into leveraging Power Query's robust capabilities for handling complex data transformation challenges. This tutorial is an excellent opportunity to enhance your skills and discover practical techniques for optimizing your data processing workflows.
Make sure to hit the subscribe button to stay up to date with the upcoming videos on Power BI and Fabric - youtube.com/@PowerBIHowTo
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Ahmedx I see what you are saying, yes that would have worked. Appreciate for pointing it out. Cheers!!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@Ahmedx Thanks for the feedback. Yes, I'm aware of that 4th parameter but don't think it is relevant in this example. Thank you!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
