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