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
Update to Power Pivot!
You certainly don't see that every day! An update to Power Pivot! Power BI Blog Continue Reading
Power Pivot Relationships
I’m guessing my posts on Performance will continue to be the most popular for some time, but I’m trying to start filling out some posts on the the Fundamentals now. Last time I talked about Calculated Columns vs Calculated Fields (Measures), today we are going to discuss “Relationships”. Two Flavors of Tables There are not actually two flavors of tables. It’s not that black and white. But I think it can be useful to think of tables in this way. There are “lookup” tables (probably called Continue Reading