Posts filed under Power BI

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).

Teaching-in-Excel-Banner-Image_thumb.png

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…

Posted on September 1, 2017 and filed under PowerPivotPro, DAX, Intermediate, Power BI, Power BI Features.

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 DAXbusiness 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.

Posted on August 2, 2017 and filed under Intermediate, Power BI, DAX, PowerPivotPro.

Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)

Article by: Reid Havens

Greetings P3 Nation! I’m here today to talk about maps, maps, globes, charts, topographical representations, and…well frankly I’m out of map synonyms.

However there’s at least twice as many ways to visualize data with maps in Power BI as there are ways for me say the word map! I wonder how many times I can get the word map in this post…I’ll basically be an certified cartographer by the time I’m done writing this.