April 2010 - Posts

• Microsoft PowerPivot for Excel 2010 – book coming in September

  As you might already know, I and Alberto Ferrari are writing a book about PowerPivot 2010 for Excel. The official title is Microsoft PowerPivot for Excel 2010: Give Your Data Meaning and you can already order it on Amazon ! However, it will be published Read More... Posted Thursday, April 29, 2010 7:18 PM by Marco Russo (SQLBI) | 4 Comments Filed under: Book, PowerPivot

• How to install SpeedFiler on Outlook 2010 (aka Outlook 14)

  This is off-topic here on SQLBlog, I know, but I think there will be many users like me wanting to find the solution for this problem. If you have SpeedFiler there is a problem installing it on Outlook 2010. The setup of SpeedFiler stop showing this message: Read More... Posted Friday, April 23, 2010 11:47 AM by Marco Russo (SQLBI) | 15 Comments

• Notepad++ used as DAX editor

  If you use PowerPivot and write some DAX formula, don't miss this post on PowerPivotPro blog - if you want to get an external editor for your DAX formula, you can use Notepad++ for free - and adding the customization described in this post by Colin Banfield, Read More... Posted Wednesday, April 07, 2010 10:51 AM by Marco Russo (SQLBI) | 1 Comments Filed under: PowerPivot, DAX

• ALL, ALLEXCEPT and VALUES in DAX

  When you use CALCULATE in DAX you are creating a new filter context for the calculation, based on the existing one. There are a few functions that are used to clear or preserve a column filter. These functions are: ALL – it can be used with one or more Read More... Posted Monday, April 05, 2010 5:05 PM by Marco Russo (SQLBI) | 2 Comments Filed under: PowerPivot, DAX