Power Query (M)agic – Nested Calculations in Power Query – Finance Application
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell.
Category: Power Query
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
Power Query (aka “Get and Transform” in Excel, aka the “Query Editor” in Power BI Desktop) is a powerful ETL tool, more powerful than you might expect from something native to Excel (also a native part of the free software Power BI Desktop).
PowerQuery (M)agic: Combine M Functions and Formulas In Custom Columns
Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle.
Power Query (M)agic: Scraping ads.txt info from multiple sites
I worked most of my career as an actuary at various insurance companies. Most of the time they had systems that were built before I was born, so I spent a good portion of time getting and transforming (see what I just did?) data into a format ready for analysis.
PowerQuery(M)agic: Advance Folder Combine
What an amazing year 2018 has started out to be! Joining the P3 Adaptive team was an aspiration of mine that started in the Fall of 2013…
The Great Function Project – Part 3
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project.
Power Query (M)agic: Super SubVars
The Challenge. I love the idea behind Power Query (M)agic. These posts let Power Query users learn and share best practices (tips & tricks) that solve real problems. Query management comes up a lot.
The Great Function Project – Part 2
As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting, I could not stop using external workbook links
March Madness in Power BI
It’s time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI.
The Great Function Project – Part 1
P3 Adaptive has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success.
Power Query (M)agic: Dynamically remove leading rows AND columns
The scenario – source data sheets that are structured differently! Does Power Query sometimes seem too rigid? It’s great for defining a sequence of transformations to clean your data but […]
Power BI used for Surfing FUN!
A long time ago a peer in Financial Planning and Analysis said “Financial Planning starts in the home.” I modified the statement to “Data analytics starts in the home.”