View RSS Feed

Most Popular Blogs

  1. PowerPivot And DAX Just Got A Whole Lot Easier...

    As many readers of this blog will know, I am a huge fan of PowerPivot, and honestly believe that this is THE most important feature to hit Excel since VBA was introduced to the product. And anyone who has ever taken a course from me knows that VBA is the greatest thing to be added to Excel since the grid was mapped into rows and columns.

    For those who donít know, PowerPivot was a free add-in to Microsoft Excel 2010, and is now baked into the Excel 2013 release. It basically allows us ...
    Categories
    PowerPivot , Excel
  2. Creating a Spacer Column in a PowerPivot PivotTable

    I was amused to read Mike Alexander's blog post on Add Column Spacing In A PivotTable this morning, as I did that exact thing yesterday while working through a PowerPivot solution. At least, I did the same thing, but I did it using DAX. And in this case, DAX is even easier to use that the old method, taking one less step.

    Keep in mind I'm using Excel 2013 for this, but it should be the same in 2010.

    First I created a new Calculated Field (Measure in 2010):
    Name:  calfield.jpg
Views: 10281
Size:  50.4 KB
    ...
    Categories
    PowerPivot , Excel , PivotTables