Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different. What I want to describe in this blog post is a method forcing a parent-child hierarchy in SSAS to show the parent’s own […]

Read More

Power BI Confusion

Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version. (I gave a session on Power BI […]

Read More

Hello world!

Hi there! Although this looks like my first blog post, it actually isn’t. This is the new place for my blog, because I have already been blogging for almost 3 years at the site LessthanDot. I gathered 100 blog posts about business intelligence, SQL Server, Integration Services and other ramblings. Some more useful  than others 🙂 Anyway, […]

Read More