Factor a Number with Power Query
Today I attempted to try the Excel BI Challenge #531 (Post | Feed | LinkedIn) but got sidetracked a little...
Power Query
Make a Correlation Table with Power Query
I previously made a function to make a Pearson correlation calculation. I was doing some Python and Power BI training...
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...
Estimating German Tank Production During WWII … with Power Query?
Last night I attended my first Veterans in Data Science & Machine Learning (vetsindatascience.com) meeting. It was pretty interesting. There...
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...