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,…
You’re Good at Power BI, but Underutilized, Bored, and/or Feeling Alone? Maybe We Can Fix All That. “You folks are the only office I would EVER go back to” This is one of my favorite recent quotes, and it came…
The Journey Begins I am an accountant fascinated with data. My PowerPivot journey started in 2013 when I encountered the PowerPivotPro blog while googling to find a way to tackle a multi-dimensional financial reporting task. Because of the limitations of…
Intro How did I come to PowerPivot and the related tools? Desperation in trying to fix a process problem. How did I get to the point where I can return a reasonable answer to a data query using the Power…
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…
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…
Conditional Formatting Using Text In Power BI Desktop 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…
Intro When was the last time you had an interview with the president of the company and he was wearing shorts and a t-shirt while you were decked out in a suit? Swing back to June 2017, and that was…
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…
The Counting Early in my BI career, I learned that telling friends and family I worked in “Business Intelligence” wasn’t very helpful. Most found the phrase meaningless and a few were relieved (or disappointed) to learn it did not mean…