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.

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.

Firstly, I have to be clear that I’m not presenting a “one-size-fits-all” approach to sales commission calculations here.

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.

UPDATE:  I am no longer working at Pivotstream and do not endorse their services.  All links are removed from this article but feel free to look them up if you are interested.

Even though it is still open, the one-question poll results have stabilized.  In fact, the percentages were pretty stable even from the beginning.

 A little bit of food for thought today, delivered in a pictorial/humorous style but with a serious point. A Running Joke That Never Gets Old I’m quite fond of the […]

The Streak is Broken… and a new streak begins. Well it was a full six-month run of posting every Tuesday and Thursday, Cal Ripken-like consistency. Then last week it ended.

Almost exactly six months ago, after being a long time reader of this blog, I emailed Rob and asked him a question regarding something that I just couldn’t get my head around in DAX – Banding! 

Folks I just can’t resist a quick followup on the Rat Sniffing Project. I… just… can’t. Plus I am absolutely worn down and don’t have the energy tonight for anything that isn’t inherently entertaining.

In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.

I’ve got another article about to go live on CIMA Insight, but I’m gonna jump the gun a bit and post basically the entire thing here ahead of time.