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...
Power Query
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...
HoltWinters Revisions and Debugging Idea
First thing, I made edits to the HoltWinters Power Query Function I have been working on. For the first iteration,...
Forecasting with HoltWinters and Power Query
I’ve had to use the HoltWinters algorithm to figure out forecasting for dollar figures at work. Power BI (since it...
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...