Monthly Archives: September 2011

Custom Aggregates in DAX / BISM Tabular (part 2)

SQL Server Danali | PowerPivot This post combines two ideas The calculation of a moving average (last 30 days) as shown in a previous post Custom aggregations What I want to show here today, is how we can influence the … Continue reading

Posted in Allgemein | Leave a comment

Custom Aggregates in DAX / BISM Tabular (part 1)

SQL Server Denali | PowerPivot Custom aggregates can be created using cube scripts in BISM multidimensional (SSAS OLAP cubes). How can we do this with BISM tabular? In many cases, simple DAX calculations can solve this for us. I’m referring … Continue reading

Posted in Allgemein | Leave a comment

Moving Averages in DAX vs. MDX

SQL Server 2008 | SQL Server 2008R2 | SQL Server Denali | PowerPivot Yes, I’m a supporter of equal rights of DAX and MDX. And like many others, I can’t wait to have BISM multidimensional (aka OLAP Cubes) supporting DAX … Continue reading

Posted in Allgemein | Tagged , , , | Leave a comment