Browse by Tags

• Analysis Services
• BISM
• Communities
• Conference
• Excel
• Excel 2013
• PASS
• SSAS

• Group Sales by Age of Customers #dax #powerpivot #tabular

  I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this Read More... Posted Monday, May 06, 2013 3:16 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PowerPivot, Tabular

• DAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular

  I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog , this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this Read More... Posted Saturday, May 04, 2013 8:49 AM by Marco Russo (SQLBI) | 2 Comments Filed under: DAX, Excel, Excel 2013, PowerPivot, SSAS, Tabular

• LASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular

  During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence Read More... Posted Friday, April 19, 2013 1:28 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, Excel, PowerPivot, SSAS, Tabular

• DAX Time Intelligence for 4-4-5 Calendar, ISO Calendar and other custom ones #dax #powerpivot

  DAX offers a set of Time Intelligence functions that simplify writing DAX expressions such as YTD, YOY and other time-related calculations. However, these functions only works when some assumptions are valid: your periods should be “natural” months and Read More... Posted Tuesday, February 19, 2013 4:21 PM by Marco Russo (SQLBI) | 5 Comments Filed under: Analysis Services, DAX, PowerPivot, Tabular

• LASTDATE dates arguments and upcoming events #dax #tabular #powerpivot

  Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI , which can Read More... Posted Monday, October 01, 2012 8:04 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, Conference, DAX, PASS, PowerPivot, SSAS, Tabular

• Fact Tables with Different Granularities in #PowerPivot and #BISM #Tabular

  A few weeks ago I received a question that inspired me in writing this article about how to handle data at different granularities in PowerPivot and BISM Tabular. I think this is a common pattern when you have a budget table that contains data at an aggregated Read More... Posted Wednesday, January 11, 2012 2:35 PM by Marco Russo (SQLBI) | 4 Comments Filed under: BISM, DAX, PowerPivot, Tabular