Loading Files With Varying Schema in Power BI using Power Query

Unpivoting in PowerQuery is easy, but what if you don’t know how many columns you have to unpivot?

July 4, 2023 · 3 min · 429 words
Gazing from behind a pot-plant, is this a metaphor for DAX?

Finding the Oldest Latest Date

Understanding the requirement is often harder than the final solution.

September 15, 2022 · 3 min · 448 words
Some arty frames, nothing much to do with the content but I liked them

Filtering Date Dimensions in Power Query

Power Query shenanigans, but does it fold?

September 10, 2020 · 3 min · 440 words