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.
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!
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.
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.
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
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.
You're very welcome!
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!
Excellent Knowledgeable Video of SSAS thanks brother
Really clear and effective. I was able to grasp the information with ease.
Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell
Thanks so much! Please subscribe to view more content like this one :)
Really concrete and useful presentation! It helps me much more than dull books.
God... this guy is such a good trainer !! thank you very much Mitchell
I appreciate that!
Good demo. Thank you !
Thanks for watching!
Amazing! thanks.
Glad you enjoyed!
Great demo! Thank you :)
Thanks! Glad you enjoyed.
Thanks a lot! Such a clear and great intro for MDX.
Really a great explanation
Excellent video!!! Thank you
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?
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.
it was helpful. thanks a lot
great stuff, helped me very much , thanx a lot !
You are very welcome! Glad it helped!
If we have to apply AVG/MAX operator on sales, how can that be done?
Thank you Man , It very useful :)
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.
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
Does this apply for MS Excel Pivot Table OLAP MDX? I tried with SELECT and WHERE but it keeps giving me error.
It is applied to add-in (essbase, smartview) in excel.
Zjbs video, krasavcik!
Amazing demo. I really learned a lot. I hope to see more of this! thank you mitchell