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 […]
Month: June 2010
Use slicer values in a calculation with PowerPivot DAX
By Kasper de Jonge, crosspost from PowerPivotblog.nl A while ago i had a question on my ask a question page, Sasha wanted to do the following: How to define the date […]
Welcome Query designers!
-Guest Post by the one and only Dany Hoter! We Excel geeks aren’t spoiled with fancy query builders. We have had MSQuery for the last what? 15 years? Suffice to […]
Calling a Stored procedure in PowerPivot
By Kasper de Jonge, crosspost from PowerPivotblog.nl While building a new PowerPivot workbook i wanted to use Time Intelligent functions. One of the golden rules of PowerPivot time intelligent functions is […]
PowerPivot time intelligent functions: why use ALL() and how to work around it
Posted by: Kasper de Jonge Last week I got a most excellent question from Sasha at my question page. Using my time intelligent function screencast Sasha created a workbook using […]