Monthly Archives: August 2011

Moving Average in DAX / BISM Tabular

SQL Server Denali | PowerPivot Alberto Ferrari already wrote about calculating moving averages in DAX by using a calculated column. I’d like to present a different approach here by using a calculated measure. For the moving average I’m calculating a … Continue reading

Posted in Allgemein | Leave a comment

Semi additive measures in DAX / BISM Tabular

SQL Server Denali | PowerPivot Semi additive measures, i.e. measures that have to be aggregated differently over different dimensions, are commonly used in BI solutions. One example could be stock levels. Of course we don’t want to sum them up … Continue reading

Posted in Allgemein | Leave a comment