Two Handy Power Query Tricks for Custom Sorting and Error Handling
Learn the two advanced Power Query tricks: custom sorting using List.PositionOf to arrange categories in a specific order and an error-handling method to filter out non-date values.
Power-Query
Power Query Function to Find the Next Banking Day
Learn how to create a Power Query function that calculates the next available banking day by skipping weekends and holidays. This function is useful for financial reports, payment processing, and business workflows that require accurate working day calculations.
Python vs Power Query: Understanding Lists and Dictionaries/Records
Comparing the list and dictionary concepts in Python with the list and record concepts in Power Query, exploring how data structures are represented in both languages.
Unlocking New Power Query Tricks
Explore new Power Query tricks from the latest Power Tricks Battle by Goodly. Learn something new and share your takeaways!
Power Query Calendar Table
A calendar table is crucial for unlocking the full potential of your data model. Learn why it’s essential, common challenges with DAX, and how to quickly create one using Power Query with dynamic code you can customize.
Using List.Generate to Generate Running Total Column in Power Query
You want a more efficient way of generating running total in Power Query?
Power Query Table.Skip While Row Is Blank
Use the Table.Skip function the dynamic way.