MDX 101

[@maurotorres5675]

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.

[@PragmaticWorks]

You're very welcome!

[@abc123birdsandbees]

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

[@samitauqeer]

Excellent Knowledgeable Video of SSAS thanks brother

[@elvistsang832]

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!

[@lukasyu1204]

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

[@pow5782]

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

[@juanm555]

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

[@PragmaticWorks]

I appreciate that!

[@FoodieMing]

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

[@severtone263]

Great demo! Thank you :)

[@PragmaticWorks]

Thanks! Glad you enjoyed.

[@polinasemykina7660]

Good demo. Thank you !

[@PragmaticWorks]

Thanks for watching!

[@sahuanalogchannel]

Really a great explanation

[@georgemelek]

Excellent video!!! Thank you

[@fernandoarce804]

Amazing! thanks.

[@PragmaticWorks]

Glad you enjoyed!

[@nusratchowdhury50]

it was helpful. thanks a lot

[@ikihidayat6707]

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])-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.

[@aytech6867]

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?

[@chrispacho5043]

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

[@PragmaticWorks]

You are very welcome! Glad it helped!

[@Mastaafa]

Thank you Man , It very useful :)

[@PragmaticWorks]

Thanks. That means a lot to us. I am not sure if you know, but we offer many On-Demand Learning courses, such as, Power BI, Azure, SQL Server, Data Science, Business Intelligence and much more. You should check out our FREE trial: www.pragmaticworkstraining.com/trial-registration/?source=odl_youtubeorg - No credit card required and you will get instant access of all our courses.

[@nandhinim7100]

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

[@ashish7750]

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

[@Dunblide]

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

[@fanglanwang911]

It is applied to add-in (essbase, smartview) in excel.

[@CtfXable]

Zjbs video, krasavcik!

[@fanglanwang911]

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

[@PragmaticWorks]

Thanks so much! Please subscribe to view more content like this one :)