A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure that can be summed across some dimensions, but not all. Typically it’s the time dimension that isn’t additive. For example, the stock level at various warehouses. You can add all the stock levels of your […]
Month: November 2016
SQL Server 2016 service pack 1 is here!
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here. Why, you ask, is it so important? Because a lot of Enterprise Edition database engine features are now available in the other editions as well. In other words, you can now enable compression and use […]
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my knowledge of DAX (read: finally understand how CALCULATE works). I’ve been following the website powerpivotpro.com for quite some time now and they always have very insightful articles about DAX and real world scenarios. Anyway, Rob Collie […]