DAX – The Greatest Formula in the World, Part Two
OK, if you recall from part one, we had a “year over year” time machine calculation going on, and it was built against a data set that lacked a “real” […]
Category: Skill Areas
DAX – The Greatest Formula in the World, Part One
You remember the Great Precedence Project? Well, I have shelved it for now, for two reasons:
Adding State Alpha Sort to the Sort By Slicer Trick
Sorting by State! How did I miss that? In a comment on Thursday’s post, Janet asked an excellent question: what about sorting by state name?
Using Excel CUBE Functions with PowerPivot
Arriving Here from a Search Engine or via Excel Help? This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of […]
Guest Post: Dany Hoter on Cube Formulas
“OK, I want the brooding frontman in the foreground, and the keyboard player and drum machine programmer in the back.” -Photographer for the EuroSynth band, MDX I’ve always loved this […]
Introducing CUBESET() and CUBERANKEDMEMBER()
“Where does he get such WONDERFUL toys???” -Kasper de Jonge (To be honest, Kasper probably looks nothing like this. I’ve never been to the Netherlands, but based on the fashions […]
Parameterizing the report
In the Parameterized Report, how do I get the “Fan Pts” column on the far right of the cube formula report to respond to those parameter cells in the top […]
Pulling back the curtain: Intro to Cube Formulas
OK, last week I showed you a parameterized PowerPivot report that contained no pivots anywhere. How did I build it? Best Tutorial: Start with a Pivot The easiest way to […]
What is Power Pivot?
So what is Power Pivot? I think a lot of people arriving at this site for the first time already know quite a bit about what Power Pivot is, but […]