P3: Why I STILL Teach DAX in Excel: My Lament to Microsoft

Article by: Reid Havens

Welcome back readers! Today I want to talk to you about a few the reasons why I still like to teach DAX in EXCEL. A HUGE part of our jobs here at PowerPivotPro is teaching analysts & data junkies throughout the world how to use the best features of Excel and Power BI. Teaching is in our blood, we love doing it, and frankly we’re great at it (I definitely know this is last part is true because my even mom told me).

P3: DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)

Article by: Fred Kaffenberger

Report Design by: Reid Havens

In 2013, Rob showed how to use a disconnected table and slicer to show moving averages with a variable time period. That post built on an earlier post, which steps through the process of creating moving averages. What-If-Parameters, teased at…

P3: DAX Reanimator Series – Part 3: Compare Product Performance After Launch

Welcome back readers, to another chapter in the DAX Reanimator Series! The post I’ll be re-envisioning today is one I’m very excited about. It’s an article that does some really cool magic using DAX, business logic, and a clever model design. It showcases a problem and solution that I think a LOT of companies experience. Frankly, if you sell a product or service, good chance you want to know how successful it is after launch.

P3: Power Query (M)agic Part 2: Organizing Your Queries

Article by: Reid Havens

Welcome back P3 Nation for Part 2 of our Power Query (M)agic series! Today I’ll be addressing an issue many of us have experienced, what to do with the LAUNDRY LIST of PQ queries you have. Since it feels really awkward to say Power Query Queries…for the rest of this post they will be simply called queries, keeping it simple folks! Any respectable data model often ends up with a plethora of queries. The more queries you have, the harder it is to navigate or find the one you want. This is where today’s solution comes in!