SWITCH() and Power Query – Part III: SWITCH() Harder
Live photo of me maintaining peak energy efficiency by switching off lights. The saga continues. As I attempted to make...
Chris Aragao
SWITCH() and Power Query – Part Deux
Can Power Query use conditional recursion to replicate a SWITCH() function? Iterate on the words below to find out. Yesterday...
SWITCH() with Power Query
SWITCH() is a monster of efficiency, but can it be used in Power Query? I have used some version of...
Make Multi-Column Dimensional Tables with Power Query
A man making dimensions in the Fabric of space and time (pun intended) Further Down the Rabbit Hole Yesterday I...
Make Dim Tables with Power Query
A man staring into the multi-dimensional abyss of data modeling Star schema is something that once you can understand it,...
Round DateTime With Power Query
When working with Power BI and datetime and datetimezone data types, the level of granularity presented with down to the...
Anatomy of a SVG (Updated 12.29.2023)
I have been posting about SVG on LinkedIn. I have about 12 slides in a PowerPoint deck and it is...
Automate Power BI Report Server with PowerShell
I develop in both the Power BI Service (Service) and on a Power BI Report Server (PBIRS). Most people would...
Target Card with SVGs
I was playing around again with SVGs and the order of the SVGs certainly matter. I practiced setting the order...
Fun with SVGs – Line Chart Card
I am having a lot of fun learning SVGs. I had used them before in various things, but I only...