Slicers For Value Fields
Earlier this week I received an email asking for help with a Power Pivot model. The issue was that the individual had built a model, and wanted to add slicers for value fields. In other words, they’d built the DAX
Earlier this week I received an email asking for help with a Power Pivot model. The issue was that the individual had built a model, and wanted to add slicers for value fields. In other words, they’d built the DAX
We are very excited to announce that we will be hosting an "Introduction to Power Excel" session in Victoria, BC on June 6, 2014. PowerPivot is revolutionizing the way that we look at data inside Microsoft Excel. Allowing us to
Hi everyone, I’m doing a quick survey on what fields/formats people include in their PowerPivot calendar tables. The info will be used so that I can include the most common formats in a Power Query script that I’m developing. If
Several years ago, when Power Pivot first hit the scene, I was talking to a buddy of mine about it. The conversation went something like this: My Friend: “Ken, I’d love to use PowerPivot, but you don’t understand the database
Anyone who follows my website or Facebook Fan Page knows that I’m a huge fan of PowerPivot. Well great news now, that you can come and learn not only why this is the best thing to happen to Excel in
A couple of weeks back I was approached by PackT Publishing, asking me if I’d be willing to read and post a review of Creating Data Models with PowerPivot How-to, by Leo Taehyung Lee. As I’m always interested to see
When I was down at Microsoft for the MVP Summit, I suggested that, as the “other most powerful part of Excel” that PowerPivot, like the Visual Basic Editor, should be given it’s own keyboard shortcut. Since Alt + F12 is
As an accountant, I build financial reports, and one of the issues that we have to deal with is getting the numbers to display in a friendly format. Because of the way that debits and credits are stored in databases
The method for hiding items with zero totals in a PivotTable is different if you're working with a regular PivotTable or a PowerPivot PivotTable. This article focusses on how to accomplish this goal in the PowerPivot version. (If you're working
Mike Alexander has a great blog post on how to Add Column Spacing In A PivotTable. We can also accomplish the same thing through a PowerPivot solution, but using DAX. And in this case, DAX is even easier to use
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.