skip to Main Content


Anonymous and Quick – This is the Whole Survey
(Please Click Image to Submit Your Answers)

In my other post today, I mentioned that I think many readers of this blog are still one small step away from that “lightbulb moment” – the moment where suddenly, your PowerPivot skills expand by 5000%, seemingly all at once.

I’d like to get a more precise sense of this, so that I can tailor future blog posts accordingly.  So please take the ~20 seconds it takes to answer this anonymous survey.  Click the image above to respond, there’s no login required.  Just click the right bubbles then click Done.

Oh, and if you’re wondering what I mean by the “Spicy Scale,” see the post behind this image:

DAX Spicy Scale

Click to see the original post

Rob Collie

One of the original engineering leaders behind Power BI and Power Pivot during his 14-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, PowerPivotPro has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.

This Post Has 3 Comments
  1. Glad you brought up time intelligence using CALCULATE() and FILTER(). My goal remains to come up with a really efficient method to combine Aggregation (TYD, Rolling 12 total, etc.) with Comparison (Last year, last month, %change, etc) that lets user “pick” the combination with a utility slicer. Parts of the greatest formula in the world get me there and it works but eventually breaks down and gets REALLY slow. Any plans to revisit some of these concepts?

  2. I feel like I have really had an explosion in my understanding of most of the listed topics, but when trying to use earlier I get completely flummoxed.

  3. My company does not use a normal calendar system or fw calendar. I’ve never attempted to use the prior year, month, etc functions. I always use another table just to hold our own calendar fw, months, quarters.

Leave a Comment or Question