TheColorAPI + PowerQuery = Color Scheme
I was looking at APIs and found a very cool one: The Color API. It is a nice API that...
Chris Aragao
PowerShell, ImportExcel, and Formatting DAX?
ImportExcel is a really cool PowerShell module. I’ve used it before to export data from SQL Server and then upload...
- DAX / PowerShell / VBA
- 0
- Read More
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....
Factor a Number with Power Query
Today I attempted to try the Excel BI Challenge #531 (Post | Feed | LinkedIn) but got sidetracked a little...