PowerPivot ROI Comparison: CIMA Part Three
It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!
It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!
Intro from Rob: today, Colin finishes in Percentile Measures topic from last week.
Note that 1) this technique requires the new release of PowerPivot that is currently still in beta (the Denali release)…
Equivalents of Excel’s Percentile, Quartile, and Median functions are perhaps the most significant omissions in Denali’s DAX statistical function library. Quartile and Median are actually special cases of percentile, and in this post, we calculate these special cases.
I occasionally look through the logs of what people were Googling (or Binging etc.) when they found their way to the blog.
I’ve always loved the concept: we know the universe is essentially a lot “heavier” than all the things we can see
A long time ago I did a post on using slicer selections in Excel formulas. That technique only worked when you select single values on slicers, though – any more than one and the dreaded “(Multiple items)” foils your well-laid plans.
I’ve had this on my list to share for a long time, but David Churchward’s recent guest post bubbled it to the top
I get a reasonable number of questions in email each week, and rarely have time to respond to all of them. Last week though I received a question that I […]
“Stay close! Come together! Staggered columns! Staggered columns! I mean… less columns! More rows!” -General Maximus Speedicus Queryus A Long-Held Belief, Quantified For a long time now I have been […]
Well folks I haven’t had much time to play with the V2 Beta (aka CTP3) yet. A lot going on over the past week:
CTP3 Adaptive = “Public Beta” What the heck is a CTP, you ask? Well it’s a “Community Technology Preview.”
PowerPivot provides a host of great functions like DATESYTD, DATESMTD, DATESBETWEEN, etc. that are useful for calculating many things, including a running total. But with the exception of DATESBETWEEN,