Power Query Challenge - Get Dates with orders Less than the previous Date
Hello and welcome! In this video, we tackle a Power Query challenge posted by Microsoft MVP Crispo Mwangi. We have a table called "Date & Orders," and our goal is to identify dates where the order is less than the previous date's order. This process can't be done directly in Power Query, but we have a step-by-step workaround. Follow along to learn this useful technique for various scenarios where row-to-row comparison is needed.
If you find this video helpful, please give it a thumbs up and subscribe to my channel for more Power Query tips and challenges. Thank you for watching!
'Power Query Challenges' Playlist:
• Power Query Challenges...
Links:
Crispo Mwangi
1) LinkedIn Profile: / crispo-mwangi-6ab49453
2) KZitem: @crispexcel
3) Power Query Challenge: www.linkedin.com/posts/crispo...
4) Download Workbook:
shorturl.at/wQibQ
Timestamps:
00:00 - Introduction to the challenge
00:10 - Loading data into Power Query
00:24 - Adding an index column
00:43 - Adding a custom column for date comparison
01:16 - Adding condition to compare current and previous orders
01:45 - Handling errors in the formula
01:51 - Filtering out empty rows
02:11 - Finalizing and formatting the dates column
02:23 - Conclusion and additional tips
#PowerQuery #MicrosoftExcel #DataTransformation #ExcelTips #PowerQueryChallenge #DataAnalysis #ExcelMVP #ExcelTutorial #CumulativeSum #excel
Негізгі бет Power Query Challenge 02 - Get Dates with Orders Less than the Previous Date
Пікірлер: 4