Topic: MDX

       227 blog posts of 231 posts
blog post –

New formula to compute new customers in #dax

Two years ago I and Alberto Ferrari spent time discussing techniques to calculate new and returning customers, and we wrote the result of our study in the New and Returning Customer article in DAX Patterns web site and book . During one of the Mastering  Read more

blog post –

Internet of Things in 2015 #summit15 #sqlpass

David DeWitt and Rimma Nehme delivered the day 2 keynote at PASS Summit 2015 talking about Internet of Things. Many PASS attendees know David for providing some of the best keynotes every, technical and without vaporware and marketing stuffs. So this  Read more

blog post –

When to use calculated tables in #dax

In the September release of Power BI Desktop, Microsoft introduced a new important feature: calculated tables. Chris Webb wrote a quick introduction to this feature, and Jason Thomas published a longer post about when to use calculated tables . The reason  Read more

blog post –

Fix performance issue of pivot tables with Tabular models

If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012  Read more

blog post –

Passing parameters to DAX measures

You cannot create functions in DAX, and this is a limitation to certain abstractions you might want to implement for complex models. I used a pattern that allows you to “pass an parameter” to a DAX measure, simulating the behavior of a function at least  Read more