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...
Chris Aragao
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...
Making Custom HTML Tables with PowerFx
What follows is another journey into using PowerFx to do abnormal things. Tread carefully. Lately I have been using the...
Calling USASpending API with Python
At work this week I spent some time diving back into Python. I had some ETL jobs to think about...
Intro to PowerFx For T-SQL Developers
I was working on an app that required a new screen. I was asked to take a screen that had...
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...
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...