Power Query - Running Occurrence Counter 🔢🥇

📊 Welcome to today's tutorial where we dive deep into the world of Power Query to create a Running Occurrence Counter using the List.Generate function! 📊
👨‍🏫 What Will You Learn? 👨‍🏫
The basics of the List.Generate function 🌱
How to use List.Generate to create a running occurrence counter 🔢
Best practices for utilizing Power Query for data manipulation 🛠️
📝 Why List.Generate? 📝
This function is not just a feature; it's a game-changer! List.Generate is a highly versatile tool that can save you time and enhance your data manipulation capabilities. By the end of this tutorial, you'll be able to create a running occurrence counter like a pro! 🥇
Note :
I've done a video on achieving this very same result using Groupings in Power Query - this is a potentially more optimal solution to do the same
• Power Query - Index Co...
#dataanalytics #datacleaning #powerbi #powerquery #powerbidesktop #mquery #excel #exceltutorial
Link to the File used in this video
github.com/jbo...

[@danielgoncalveslima9350]

List generate and Accumulate are functions mysterious and crazy...
I hope more tricks!!
Hello From Brasil ...

[@pmo4325]

Great video! I would love a video on how to do this in Power BI 🙏

[@roywilson9580]

Thanks for the video. Interesting way to use list.generate.

[@basensei8699]

thanks man!

[@kebincui]

Each and every of your power query video is a gem.Excellent. Thank you James👍🌹

[@basensei8699]

thank you!

[@patrickyoung2106]

I agree! Gems.

[@Softwaretrain]

I appreciate the training provided. However, I'm curious if there's a specific rationale behind not using the group by feature and not adding an index to each group?

[@basensei8699]

Hey there! the intention of this video is to explore list.generate. At the end of the video i state that it might not the the most optimal way of doing it but it demonstrates list.generate. i did do a video on using grouping to achieve the same ua-cam.com/video/JpqJxiZFXRk/v-deo.html have a most excellent day!

[@Softwaretrain]

@@basensei8699 Indeed, you've provided a thorough explanation of the list.generate function. Thank you for that. Nonetheless, it's valuable to have informative content even when considering alternative solutions.

[@patrickyoung2106]

@@Softwaretrain correct-a-mundo!

[@jerrydellasala7643]

Just FYI, the query was PAINFULLY slow. By buffering the two lists, it became almost instantaneous!