Category: DAX

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

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

Aged Debtors–Dynamic Banding in DAX

Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects.  The die-hard “non-accountant” Excel […]

Written by on April 17, 2012

DAX – The Correct Usage of EARLIER()

Tonight I was looking at one of my recent posts, the one about “fuzzy” time relationships in calculated columns, and I discovered that I had used the EARLIER() function in places that I did not need to.

Written by on March 8, 2012

Converting from Peaks to Frequencies Using DAX

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.

Written by on February 16, 2012