Using Lists and Functions with List.Transform()
Another thought experiment on Power Query. I was thinking about how to do a number of checks against text in...
Power Query
With(), Let, & VAR: The Three Amigos of Power Platform Efficiency
I started a new job recently as a Power Platform Developer and it has been fun doing more work with...
Using Table.Profile() and Table.Schema() for Max Impact
Table.Profile and Table.Schema are two table functions that can by themselves provide a lot of information about a table in...
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...
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 Pearson Correlation Coefficient with Power Query
I can’t tell if that pear in the water is a buoy or if it is a child that the...
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...