Multidimensional Expressions (MDX) is one of the more challenging languages in the BI world (M in PowerQuery is probably the next in line). It’s probably because our brains are trained to think relational and with MDX you have to think “layers”. I picked up DAX pretty easily, but kept searching for a way to understand MDX.
I’ve Googled, asked brilliant MDX coders, watched YouTube videos, etc., but I just couldn’t find a simple explanation. I have to admit, reading technical jargon is rough on my brain. Then I found this video and voila! Finally, someone who could explain MDX to me in English! Watching this video makes you feel like someone is sitting right next to you to explain MDX.
In this video, Rob explains the structure of an MDX query in relation to a SQL query, which is very helpful when trying to build your MDX query. He then goes on to explain what is different about MDX syntax (brackets, members, tuples) and how it is used. So tuple schnuple…watch this and you’ll be writing MDX in no time!
Looking for more resources? Check out our knowledge center.