Last month I saw a puzzle posted on fivethirtyeight.com about poker hand probabilities and, like with many things these days, wondered how I could solve it with PowerBI. I had been curious to learn more about the M list functions,…
Humans like turning a few things into many things. Investing $1 to get $10 . . . growing saplings into oaks . . . taking two rabbits and creating a fluffle. This post will show you how to do…
Background Think back to the year 2012 when Microsoft introduced us to SQL Server Analysis Services Tabular models. It was new and exciting. The Excel gurus who had been using PowerPivot since 2010 were sneering at us like we were…
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…
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,…