I’ve Googled for MDX Cheat Sheets, found a couple, but never exactly what I was looking for.
So I made my own, hope this one explains things a lot easier for you (and also as a reference for myself) 😉
For the demo, I’m using a Year(2014)/Month(201401) hierarchy in my SSAS cube which looks like:
SSAS MDX Cheat Sheet
Here’s another MDX Cheat Sheet I posted after, all about Calculated Measures: