In the previous post in this series I looked at how MDX set expressions could be used inside Excel to give you total control over what appears on the rows and columns axis of your PowerPivot ...

Some Excel functions that can pull data directly from the PowerPivot datamodel (basically like a super lightweight RDBMS inside Excel designed to take your pivot tables to the next level) require you ...

The combination of the filtering functionality built into PivotTables, and the ability to delete and reorder tuples in a set without needing to edit the set expression itself that the Excel named set ...

Have you found this content useful? Use the button above to save it to your profile. Business intelligence expert Philip Taylor (aka ExcelCrafter) puts the case for using the PowerPivot add-in for ...

Last week I pulled a new pair of running shoes out of the box and laced them up. As much as I love running and a pristine new pair of shoes, I have no intention of giving up my bicycle or car and ...