Find Different Sample Standard Deviations with Power Query
Recently I posted a function that helps calculate different averages. One major issue when using the arithmetic mean is that...
function
Calculate Different Averages with fnMegaAverage()
The tween finishes Dad with the epic finishing move, “Dad, you’re mega average!” I was doing some training on a...
Use the Standard Normal Distribution (Z) Table with Power Query
If drawn to scale, that wrestler is frighteningly large The Standard Normal Distribution Table is often referenced in statistics textbooks...
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...
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...
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() 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,...