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...
Power Query Idea: Import M Code extensions from a Power Query Gallery
…and then Fabricus wrote the idea down into the scroll… I posted an idea to LinkedIn recently regarding ensuring that...
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....
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...