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,...
Round DateTime With Power Query
When working with Power BI and datetime and datetimezone data types, the level of granularity presented with down to the...