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...
Power BI
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...
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...
Calculating ErlangC with Power Query
I was interviewed by large non-profit for a volunteer project and I was asked about how to apply ErlangC in...