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.

February 15, 2025 · 2 min · 228 words

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.

February 5, 2025 · 3 min · 531 words

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.

February 5, 2025 · 3 min · 564 words

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!

November 30, 2024 · 1 min · 129 words

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.

November 19, 2024 · 2 min · 289 words

Using List.Generate to Generate Running Total Column in Power Query

You want a more efficient way of generating running total in Power Query?

March 19, 2024 · 1 min · 34 words

Power Query Table.Skip While Row Is Blank

Use the Table.Skip function the dynamic way.

July 23, 2023 · 1 min · 66 words