Solving the Query – Pivot Edition
Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation
Category: Power Query
Working with Lists in Power Query – Let’s Count Words
Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may not realize it, so if you add some List knowledge to your quiver, you’ll be able to kick your Power Query skills up a notch.
How Can I get a Lookup Table from a Slowly Changing Dimension (SCD)?
Your Power BI model is fed by a data warehouse, and you’d like to make some reports, but now your Customer table has several entries for each customer instead of one.
Power Query (M)agic: Parameters for Dataflows!
I’ll get to parameters for dataflows in a bit. To begin, let’s talk about dataflows. Dataflows are Power Query queries that live outside of Power BI reports and can be refreshed on a schedule within Power BI service.
PowerQuery(M)agic: Conditional Joins using Table.SelectRows()
In a recent project with one of our clients, we were attempting to categorize website visit logs, based on the visitor’s landing page.
Automated Testing With Power Query
I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality.
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.
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.