Video - MDX and DAX-compare and contrast
MDX and DAX are both promoted as analytical languages. Despite the initial confusion when DAX was announced, Microsoft sees both as a part of its BI strategy (at least, that's what it told us last time we asked.). So far, so good. You want to keep up with the Microsoft approach to the BI world, so the obvious answer is to learn both. And, let's face it; they can't be too dissimilar can they? They are, after all, both analytical languages.
Well it turns out they are very different. Indeed, it would be difficult to imagine two languages, both designed to analyse data, that were more unalike. This begs a number of questions.
Read more...