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…
Why Fly Home Tuesday Night? Make it an epic week. Join me in Seattle for a full week of Power BI Goodness Hi folks, in what’s become a tradition, we like to teach classes in Seattle and schedule them consecutively…
Disconnected Slicers With DAX Variables & SELECTEDVALUES Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially…
Today, we'll look at Power BI workspaces, apps, and how to keep changes from mucking up reports. In the software development lifecycle, a distinct space to test new reports ensures consistent results. Moreover, it's part of good governance. This post builds…
What an amazing year 2018 has started out to be! Joining the PowerPivotPro team was an aspiration of mine that started in the Fall of 2013… I wanted to BE a part of this team and this community – to…
How to Create A Real Time Dataset on Power BI.com Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written…
Hello P3 Nation. Today’s post is going to be short and sweet. Here at PowerPivotPro, we’re always working to improve our blog and bring the best content to you, our readers. So we’d LOVE it if you’d take a moment…
Lord of the Rings. Mad Max. Star Wars. Indiana Jones… The Great Function Project. Another great trilogy comes to an end… well at least until the next one comes out. If you haven’t “seen” part 1 & part 2, go…
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. What if multiple PQ queries point…
The Rewarding Things Aren't Easy Sometimes I forget that it has only been a year at PowerPivotPro. Every new client that I have seems like I‘ve spent months getting to know a business, their projects, and the incredible people…