MDX 101

The MDX query language is one of the toughest and most powerful languages in your arsenal as a business intelligence developer. In this session, you’ll start from the ground-up learning how to create a basic MDX statement and then quickly how do you solve complex business problems with this well-structured language.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:

Let's connect:

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]

[elvistsang]

This is amazing! Though if you don't mind constructive criticism, I would much prefer the backspace around the screen recording to be gone, but it is otherwise a fantastic tutorial!

[maurotorres]

This was a fantastic tutorial. I learned SSAS about 5 years ago, but haven't used it since then, so this was the perfect tutorial to refresh my memory. Also thank you for your good indentation. It really helps for learning. You're a talented teacher.

[samitauqeer]

Excellent Knowledgeable Video of SSAS thanks brother

[abcbirdsandbees]

Really clear and effective. I was able to grasp the information with ease.

[lukasyu]

Really concrete and useful presentation! It helps me much more than dull books.

[juanm]

God... this guy is such a good trainer !! thank you very much Mitchell

[fanglanwang]

Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell

[FoodieMing]

Thanks a lot! Such a clear and great intro for MDX.

[ikihidayat]

I have a question in related to MDX calculation. The question is How to display last 5 years in Power BI using MDX Calculation? Let me know if you have solution on this.


I have solved the calculation previously in DAX Power BI just for reference. The Dax formula for this case here and I attached the visualization example:

Last 5 Years = CALCULATE(SUM(Dummy[Value]), FILTER(Dummy, Dummy[Year]<=SELECTEDVALUE(Calender_1[Year])&&Dummy[Year]>=SELECTEDVALUE(Calender_1[Year])-4))


The problem is, I need to create the calculation using MDX because the data source is Multidimensional Analysis Services.
Much appreciate for your helping.

[ashish]

If we have to apply AVG/MAX operator on sales, how can that be done?

[chrispacho]

great stuff, helped me very much, thanx a lot !

[ahmadyamout]

I am new to power bi and I need a mentor . Is this video of mdx sufficient to learn from it and apply for a job that is in need of it?

[nandhinim]

Thanks a lot . It's very helpful to me, but I have an doubt after deploy the SSAS our end user will see the report using SSRs graphical view, they are not writing those mrx queries in sqlserver right ? If yes then why we need this. Could please clarify me

[Dunblide]

Does this apply for MS Excel Pivot Table OLAP MDX? I tried with SELECT and WHERE but it keeps giving me error.

[pow]

Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell