Posts tagged #Excel

P3: Disconnected Slicers With DAX Variables And SELECTEDVALUES

Article by: Reid Havens

Today’s topic covers how to create a Disconnected Slicer using DAX Variables and SELECTEDVALUES. We’ve easily written a few dozen articles over the years on ways to use disconnected slicers, and here’s another one!

The great thing about DAX is that as it EVOLVES, writing measures and utilizing certain features becomes easier. That’s the goal of this video, it’s not re-inventing the wheel, just refining it. I’ve included below the original DAX Formula I used in the walkthrough. Otherwise, enjoy the video!

P3: Coffee Talk: PowerPivot Utilities

Welcome to the latest PowerPivotPro Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel and are then lightly edited for publication. In this installment of our Coffee Talk series, we’ll be chatting with The Power Pivot Utility team: Bertrand d’Arbonneau and Marco Russo, along with P3’s Reid Havens and  Matt Allington. Let’s introduce everyone.

Posted on February 22, 2018 and filed under Tools & Software, Industry, Excel, PowerPivotPro.

P3: Power Query (M)agic Part 3: Divide & Conquer

Article by: Reid Havens

Welcome back P3 Nation! By now we’re in full swing with this Power Query (M)agic series, three posts and counting! You’re now knowledgeable enough about Power Query (if you read Part One and Part Two, anyway) that I want to throw some cool techniques at you involving M code. The time has come to take off the metaphorical training wheels, dive into the deep end, leave the nest, take a leap of faith (boy does this guy love idioms…), because frankly you are READY FOR IT“I know it, you know it, everyone knows it.”

Posted on November 9, 2017 and filed under Power Query, Intermediate, PowerPivotPro.

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