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.
Category: Data Strategy
Using DAX Magic For Variable Forecasting
I often have inputs I know today and want to “run them out” into the future applying certain parameters along the way to create a projection.
On the Right PATH() – A DAX/Power Query approach to working with parent/child hierarchies.
One of my colleagues and I have been geeking out the last few years over all things Power (Query, Pivot, View, and now BI).
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
Today, I’ll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles… and yes, I’ll throw in a Greatest Formula In the World (GFITW) version, too.
Coffee Talk: The Tabular Pros
Ok so we missed a week. We had a busy training in Denver last week. Good news is we’re baaaaaaaaaack and with a great lineup of Tabular Pros.
Individual Excellence vs. Organizational Impact: Know the Difference!
What We Can Do With “Just” DAX and Modeling. It’s my experience-powered belief that you cannot get a Win of that size without leveraging DAX and Modeling.
M/Power Query “Sets Up” DAX, so Learn DAX (and Modeling) First
You should advance to Intermediate in DAX before advancing to Intermediate in Power Query / M, and then to Mastery of DAX before Mastery of M.
New Reports From Existing Datasets
Learn how to upload a Power BI desktop file to PowerBI.com by following these short, simple steps.
Roundtable: Better IT/Biz Relations in the Power BI Era
New Feature: Roundtable. Welcome to an experimental new feature here at P3 Adaptive , where members of the team discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on our Slack channel, and are then lightly edited for publishing on Friday.
Nerds-Turned-Bullies, the Rise of the Brogrammer, and Are Analytics Good for SQL People?
Today I want to go off-topic just a little bit, but in a way that I think is relevant to many of us as professionals. And then bring it home, so to speak, specifically at the intersection of Analytics and Databases.
Designing for Usability in Power Pivot and Power BI
An article on improving the usability in Power Pivot and Power BI as well as where the current program is at now and how to improve key flaws.
BI for Everyone: Tear Down the Wall Between IT and Business
President Reagan in his famous “Tear down this wall” address, asked for the Berlin wall to be brought down. Believing that freedom and security go together.