Extract Function Metadata in Power Query
Recently, I wrote an article about how you can mix-and-match functions and lists to perform many true/false checks at once....
Chris Aragao
Factor a Number with Power Query
Today I attempted to try the Excel BI Challenge #531 (Post | Feed | LinkedIn) but got sidetracked a little...
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...
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...