View RSS Feed

The ExcelGuru (Ken Puls) Blog

This is where I share opinions and rants, test material, share site updates and stuff like that. If you like Beta software, this is a good place for you. If you don't, well... you may not want to try much of what I post here.

  1. 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: 11612
Size:  50.4 KB
    ...
    Categories
    PowerPivot , Excel , PivotTables
  2. Training Calendar Updated

    I've been working away this weekend, putting the finishing touches on the webinar that I'm leading on Tuesday AM. It occured to me in the process, that I'd been rather remiss in updating my Training Calendar on the site. So this evening I took the time to pop in and add a few of the events that are coming up.

    So now in the calendar, we've got:

    ...
    Categories
    Excel , Training Sessions