
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.
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.
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.
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.
Explore new Power Query tricks from the latest Power Tricks Battle by Goodly. Learn something new and share your takeaways!
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.
You want a more efficient way of generating running total in Power Query?
Use the Table.Skip function the dynamic way.