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…
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…
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…
Hello P3 Nation, welcome back to another exciting month of Power BI updates! This month’s release saw quite a few new updates and enhancements to the Power BI Universe. It’s like Christmas each month for us here at PowerPivotPro, where…
My name is Mathew Herring Jack, and I am a member of Traditional Excel Users Anonymous. As a Traditional Excel User, I could not stop copying and pasting downloaded reports. Even when my manager diagnosed me with inaccurate month-end reporting,…
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. I’m in finance, so my needs will almost always have a financial planning bias,…
It's time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI. This article explains one approach for doing March Madness Power BI style, and using everyone's bracket data to teach…
Talk About Your Personal Journey OR Share a Technique – Either Way, it’s Time YOUR Voice is Heard Are you ready to see your name in lights? Hi folks! I know, I know… long time, no write. I’ve been busy,…
Your First Co-Development Project P3 has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in…