Get Quartile Stats with Power Query
The Four Horsemen of the Sci-pocalypse Knowing what the quartiles are for a range of values is another decent way...
Calculate Z-Score with Power Query
A literal interpretation of a Z score as prompted to Copilot (kidding) What is a Z-Score? Assuming the data that...
Calculate Median Aspect Ratio with Power Query
I wish I had something witty to say for a caption, but I am mildly terrified of this image lol...
Experiments with SwitchMethod() in Power Query
“Come with me if you want to Switch()…” I have posted three times now about ways to think about a...
Use Regex in Power BI with Python & Power Query
Even snake_case text can’t hide from Regex and Python Knowing where to infuse things like Python to your Power BI...
SWITCH() and Power Query – Part III: SWITCH() Harder
Live photo of me maintaining peak energy efficiency by switching off lights. The saga continues. As I attempted to make...
SWITCH() and Power Query – Part Deux
Can Power Query use conditional recursion to replicate a SWITCH() function? Iterate on the words below to find out. Yesterday...
SWITCH() with Power Query
SWITCH() is a monster of efficiency, but can it be used in Power Query? I have used some version of...
Make Multi-Column Dimensional Tables with Power Query
A man making dimensions in the Fabric of space and time (pun intended) Further Down the Rabbit Hole Yesterday I...
Make Dim Tables with Power Query
A man staring into the multi-dimensional abyss of data modeling Star schema is something that once you can understand it,...