Dax: Back to the basics
Figure 1 View outside of my home office window May 2nd, 2018 Fairbanks, Alaska. Intro Hello, my name is Matthew Brice and I am guest broadcasting from my home office (via tape delay) in Fairbanks, Alaska. PPPro put out a…
Build as they talk
I read this blog (and Matt Allington, and Ken Puls) pretty religiously. But PowerPivotPro is probably my favorite because it deals with a lot of real-world situations, not just technical solutions. So, I’m going to continue that theme and…
Journey to P3: Krissy Dyess
My P3 Story! Well, it looks like I’m up next to share my PowerPivot and P3 story! I really enjoyed Ryan’s story, and I took away from it that you must make time for what you what to achieve in…
Finding the Magic Part 2: On the Way to Data Happiness
The journey continues… Five years on from my life-changing encounter with PowerPivot, my pilgrimage to the Nirvana of Modern Excel continues with some occasional detours. When I first encountered PowerPivot back in 2013, I thought that this tool would obviously…
Power Query (M)agic – Nested Calculations in Power Query – Finance Application
One of the most powerful features (and there are lots) that I’ve found about Power Query is the ability to hold an entire table in a single cell. Once I’ve got a table in a cell, then I can start…
Know When to Hold ‘Em – Part II. Time for DAX
In Part I, we used the query editor and the M List functions to generate all the possible combinations of five and seven cards from a standard deck. To score all the possible combinations of seven cards (133M possible hands…
Power Query (M)agic – Using Power Query to Transform and Combine Online StatsCan Data
Intro Power Query (aka “Get and Transform” in Excel, aka the “Query Editor” in Power BI Desktop) is a powerful ETL tool, more powerful than you might expect from something native to Excel (also a native part of the free…
Adding Visual Flair In Power BI With Background Colors
Adding Visual Flair In Power BI With Background Colors Hello P3 Nation! Today’s “post” is 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…
Know When to Hold ‘Em – Part I. Fun With Lists
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,…
Why Haven’t YOU Applied for a Power BI Job With Us?
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…