July 2010 - Posts

• Median calculation in DAX

  I recently discussed with Darren Gosbell about how to calculate the Median in DAX. The problem is to make the calculation using a measure, so that you can use it in a dynamic way into a PivotTable. We have a People table with three columns: Gender, Customer Read More... Posted Tuesday, July 20, 2010 1:54 PM by Marco Russo (SQLBI) | 24 Comments

• PivotViewer released

  In reality, there are two news. First, PivotViewer for Reporting Services CTP1 has been released and you can try it. Second, Cristian Petculescu has a blog and you can find a video about how to install and start using PivotViewer. Cristian is one of the Read More... Posted Saturday, July 17, 2010 12:55 PM by Marco Russo (SQLBI) | 0 Comments

• My sessions at PASS Summit 2010

  I will be a speaker at PASS Summit 2010 (November 8-11, 2010 - Seattle, WA) and sessions have been published yesterday. I am currently writing the last chapter of the book about PowerPivot that will be available in September, so I’m confident it will Read More... Posted Friday, July 9, 2010 1:10 PM by Marco Russo (SQLBI) | 0 Comments