Month: May 2012

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

Written by on May 31, 2012

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.

Written by on May 22, 2012

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.

Written by on May 15, 2012

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.

Written by on May 5, 2012

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.

Written by on May 3, 2012

DAX – Weighted Averages: Another Use of SUMX()

Another Question from the Mr. Excel Forums Got a question on the forums the other day.  It took some extra twists and turns but the simplest version of the question is worth covering here:  how do I perform a weighted average?

Written by on May 1, 2012