GetPQ: A Very Bare-Bones Tool for Power Query
So a while back I was playing around with a Power Query Shared Library. I got pretty far, but I...
Power Query
Formatting M Code with Power Automate Desktop
Previously, I had been using Github Copilot to help me generate code for a Visual Basic app in Visual Studio....
TheColorAPI + PowerQuery = Color Scheme
I was looking at APIs and found a very cool one: The Color API. It is a nice API that...
Switch with Power Query: Final Boss Battle
I will admit that I have been a little preoccupied with this problem. This all started with me watching one...
Automatically Round Off Number Columns with Power Query
I was working on additional functions for the Power Query Shared Library and thought about routine things that many people...
Dynamically Remove Characters with Character.ToNumber()
When I was writing more VBA, I found a post somewhere that showed how to pull out specific groups of...
My Own #Shared M Library: Take 1
I’ve been trying to write an M extension. I should distinguish this by saying I am not trying to write...
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....