July 2014 - Posts

• DIVIDE vs division operator in #dax

  Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced Read More... Posted Thursday, July 24, 2014 8:22 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, DAX, Excel 2013, PowerPivot, SSAS

• Issues with July 2014 Office Update and Click-to-Run #excel #powerbi

  An interesting experience with Office Click-to-Run is that trusting it to install updates the night before a conference where you are a speaker. I’m writing this blog post while Alberto Ferrari is delivering its part of the preconference training day Read More... Posted Thursday, July 17, 2014 2:11 PM by Marco Russo (SQLBI) | 2 Comments Filed under: Excel

• Use of RANKX with decimal numbers in DAX #powerpivot #ssas #tabular

  Using decimal numbers in Power Pivot and Tabular might produce small rounding differences in certain calculations. This is nothing new when you work with floating point, as many programmer knows. The implementation of RANKX might suffer of a behavior Read More... Posted Wednesday, July 16, 2014 8:22 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot, SSAS, Tabular

• Learn #tabular and #dax at PASS Summit 2014

  During the last months I’ve seen an increasing adoption of Analysis Services Tabular (and I’m writing a longer article about a particular area of adoption which was probably not expected – more on that in a few weeks). This year at PASS Summit 2014 there Read More... Posted Tuesday, July 08, 2014 6:57 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Conference, Conference Communities, PASS

• Calculate the rolling average for 12 months in #DAX and a nice IF optimization

  Alberto published the Rolling 12 Months Average in DAX article on SQLBI a few days ago, which includes interesting consideration about how to avoid the pitfall of touching the boundaries of the Date table, which could result in a calculation error. More Read More... Posted Thursday, July 03, 2014 10:51 AM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, PowerPivot, Tabular