Diff Check with PowerFx
“How dare you move my cheese!” I’ve been working on an app that deals with word processing functions in Dynamics...
Chris Aragao
Get Power Automate Fails with PowerShell
Visibility of flow failures is important in terms of managing a Power Platform environment. If something you thought was automated...
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...
Power Apps and SVG: Make Cards for Your Apps!
I was working on a Power App this week and saw that there was external data in the app that...
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...