Insight as a Service – Your Next Career?
Is Your Brain More Valuable Than You Know? ***Update: May 2015 This article is now three years old. I’ve been gone from my last company now for more than two […]
Content Type: Blog Post
DAX – FILTER() – When, Why, & How to Use It
A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function. Time to correct that.
DAX – Top-Selling Product using FIRSTNONBLANK()
First of all, apologies for being so late. I feel like a total zombie, we got to our house in Ohio 22 hours after we arrived at the airport in Tel Aviv.
DAX – Finding the Top-Selling Date, Product, etc.
Greetings from Israel! I’m over here meeting with Microsoft and my old friend Dany Hoter
KPI’s in PowerPivot V2
On Tuesday, in my intro to David Hager’s post, I promised to circle back “later today” and add some follow-on thoughts. Well, ONE of those words ended up being truthful
Conditional Formatting with Different Thresholds per Test, per Product, per Store, per Division, etc.
After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning
Percentile Measures in DAX – Errata
Guest Post by Colin Banfield [LinkedIn] In September of last year, I posted two articles on creating percentile measures in DAX. See Creating Accurate Percentile Measures in DAX – Part I and Creating Accurate Percentile Measures in DAX – Part II.
Excel 5-Calendar Date Table
For some time, I have been looking around for a fairly complete date table in Excel for use with PowerPivot.
Commission Calculations using DAX Part 2
You may recall in my last post, COMMISSION CALCULATIONS IN POWERPIVOT, we got to the point where we could dynamically calculate the sales value and attributable commission rate that should be applied based on time, value and team parameters, reading from a Rates table.
Commission Calculations using DAX
Firstly, I have to be clear that I’m not presenting a “one-size-fits-all” approach to sales commission calculations here.
Friday Bonus: What is “Stimulus Spending?”
I stumbled into an interesting discussion on Facebook yesterday, and didn’t have room to express my opinion there, so I thought I’d do it here. It’s about the economy, which has been my only real hobby for the past several years.
Beta-Testing the “ROI Quadrant”
If you’ve been around Business Intelligence for the past ten years, you’ve seen a LOT of Gartner’s Magic Quadrant. You can see the 2012 version here on Microstrategy’s web site.