Power Query - Running Occurrence Counter 🔢🥇
Вставка
- Опубліковано 8 вер 2024
- 📊 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...
List generate and Accumulate are functions mysterious and crazy...
I hope more tricks!!
Hello From Brasil ...
Great video! I would love a video on how to do this in Power BI 🙏
Thanks for the video. Interesting way to use list.generate.
thanks man!
Each and every of your power query video is a gem.Excellent. Thank you James👍🌹
thank you!
I agree! Gems.
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?
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!
@@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.
@@Softwaretrain correct-a-mundo!
Just FYI, the query was PAINFULLY slow. By buffering the two lists, it became almost instantaneous!