Browse by Tags

• DAX

• 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

• Sorting Dates Columns in #PowerPivot and #BISM #Tabular

  I just published an article about Sorting Dates Columns in PowerPivot v2 and BISM Tabular on SQLBI website. In reality, the article is about sorting columns by other columns in a Tabular model, but the common scenario in which you need that is in a Calendar Read More... Posted Thursday, December 08, 2011 1:15 PM by Marco Russo (SQLBI) | 2 Comments Filed under: BISM, PowerPivot, Tabular