The folks over at PowerPivotPro have blogged like… everything under the sun about Power Pivot. It’s always a bit embarrassing to search for a technique like… the formula for a calculated column for “End of Week” date… and it turns out that *I* wrote it on PPP blog and forgot about it . Anyway, I was starting this article and decided to do something crazy and search for it first… and naturally, they already have it blogged. Their technique is super fancy. This is so simple Continue Reading
DAX CONTAINS( ) function
Happy 2015 Power Pivot Freaks! Should be an exciting year as Microsoft seems intent on pushing forward with its self-service BI strategies and the Power BI stack. I suspect we will see a new version of Office this year, so I will be excited to see which of my dreams come true. Today I wanted to talk a bit about the CONTAINS() function. The msdn reference gives one example, but it’s a bit rough to come up with scenarios where it’s really applicable. I saw a great example from Chris Webb Continue Reading
Playing with Median Age Data
Now Power Pivot learnings here, just Scott being a total data geek. I am watching the Chicago Bears holding their own against the Detroit Lions (backup QB for Chicago looks strangely solid)… but because I have massive ADHD like to multi-task I was also looking at this article on where young and old people live. Being “Data Curious”, I brought in the data from the CIA World Factbook and added a simple ratio… of the male to female median ages. For example, in the United Arab Emirates, the Continue Reading
The DAX EARLIER Function
When I give a Power Pivot training, this is one of the harder concepts to explain. It’s not something easy for a complete Power Pivot beginner to understand… but there is a general pattern you can use anyway, without completely understanding it. Good thing, because it a SUPER useful function. By the end of this post, you will better understand Row Context, the EARLIER() function… and have the absolute worst stock analysis ever. Row Context Before we really dig into this bad boy, the first Continue Reading