PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

Pointers: Samples and Tutorials

By powerpivotgeek (dwickert@hotmail.com), on October 4th, 2010

I wanted to consolidate all of these into a single posting:

Roadmap to Creating PowerPivot Workbooks in Excel: http://technet.microsoft.com/en-us/library/ee210641.aspx
PowerPivot for Excel Tutorial: http://technet.microsoft.com/en-us/library/ee835510.aspx
PowerPivot for Excel Samples: http://go.microsoft.com/fwlink/?LinkID=192753&clcid=0×409
PowerPivot for Excel DAX Samples: http://go.microsoft.com/fwlink/?LinkID=192754&clcid=0×409

Enjoy!

_-_-_ Dave

October 4th, 2010 | Category: "Getting Started", DAX, Sample Code | Leave a comment

When is null not a null?

By powerpivotgeek (dwickert@microsoft.com), on February 15th, 2010

Recently there have been some discussions on the forums and in other areas concerning how PowerPivot handles nulls. As this has changed between CTP3 (back in November) and the upcoming RTM of the product, I thought that it would be a good posting. Here is the situation: suppose you have a simple calculated measure:

m1 [...]

February 15th, 2010 | Category: DAX | One comment