DAX – Finding the Top-Selling Date, Product, etc.
Greetings from Israel! I’m over here meeting with Microsoft and my old friend Dany Hoter
Category: DAX
DAX – Making the “Case” for SWITCH()
Way back during the period of the first CTP of Gemini (which later became PowerPivot), I was working with a data set that included a column of month numbers
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.
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.
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?
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 […]
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.
DAX – Subtotals and Grand Totals That Add Up “Correctly”
Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.
DAX – Correlating “Fuzzy Time” Events in One Table with Precise Measurements in Another Table
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.
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.
Peak Detection: A Surprising Usage of DAX
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.