Switch with Power Query: Final Boss Battle
I will admit that I have been a little preoccupied with this problem. This all started with me watching one...
Power BI
Dynamically Remove Characters with Character.ToNumber()
When I was writing more VBA, I found a post somewhere that showed how to pull out specific groups of...
My Own #Shared M Library: Take 1
I’ve been trying to write an M extension. I should distinguish this by saying I am not trying to write...
Using External SQL Files to Get Data with Power Query
I am a big fan of writing SQL with Power Query. I do a lot of exploration with SQL and...
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...