What is DAX? 

Thanks for your fantastic comment. 15 years ago I thought I knew it all. Today I’m wise enough to know I’ll never know it all 😀. We’re all learning from those who have gone through the pain of not knowing. Thanks for following along and please share with others.

@@AccessAnalytic My company already has been bombarded with your YT links :D If I could make a suggestion for another video? Cohort analysis. We do a lot of monthly and quarterly analysis, as well as a handful of YoY analysis, and knowing how to build a flexible model for this that can be sliced would be a bit of a gamechanger. There's not a lot of useful cohort videos/guides especially at the quarterly level, and it would be especially interesting to know if this could work alongside the Calendar table too! Thanks again :)

@@marcdoeseverything My DateTable video should help ru-vid.com/group/PLlHDyf8d156VDobBIk13o4mZLk19DbV81

Thanks David. Really appreciate you taking the time to leave a kind comment

Cheers Iván

Thanks very much Andrew. I'm always hoping that these things resonate with people but always nice to hear that folk find them useful. Cheers for leaving the kind comment.

You're welcome, thanks for letting me know it's useful. Yes it's a different way of thinking

Great!

Thank you very much for the kind comment

Thanks Lorenzo, very kind of you to say so

Thanks as always for your support Wayne

Glad to help Andrew, thanks for taking the time to let me know it's useful

You’re welcome Jayantkumar, thanks for letting me know you liked it

You're very welcome!

Awesome. - glad to help. DAX is indeed a different way of thinking

You are absolutely right, dax works on a typically database fashion. Actually under the hood there is a colunar database, as explained by Mike Marvin on Excellfuns!

You’re welcome

Thank you

You’re welcome Zuhair, thanks for taking the time to leave a kind comment.

No worries, thanks for leaving a comment

Great! Glad to help

You’re welcome

Thank you

Thanks for letting me know 😀

Check out my “getting started” playlist ru-vid.com/group/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

Thanks

That’s great Ayanda. Welcome to the channel

Thanks for letting me know Krishna

Thanks 😃

You’re welcome

Thanks Geert, greatly appreciated. I have a “Getting Started” playlist ru-vid.com/group/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

You’re welcome

Hi, I've just messaged you on LinkedIn to get a screenshot

You’re welcome.

Ctrl and mouse wheel 😀

@@AccessAnalytic Thank you😄

No worries

Hi, that's using Excel Tables (Ctrl T) and adding a Slicer (it's one of the options in the Excel Ribbon that displays after turning data into a Table. It's not DAX related but a way of me trying to physically illustrate the way to think about how DAX works.

@@AccessAnalytic Thank you very much! I found Slicer and was able to replicate the function. Thank you again!!

Thanks

Thanks 😊

Hi Elic, those were slicers for the Table. Turn some data into a Table using Ctrl t and then under Table Design menu pick Insert Slicer. I then changed the number of columns in the slicer to make it display as a horizontal list

@@AccessAnalytic that makes way more sense than it should. I feel like I have skipped over some of the most basic things I should know. Thank you for the reply!

I’d recommend Matt Allington’s book Supercharge DAX. pbi.guide/resources/ Or this online course version skillwave.training/shop/supercharge-power-bi-online/ I also have a chapter on DAX in my book pbi.guide/book Or for free learn.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics?WT.mc_id=M365-MVP-5002589

@@AccessAnalytic Thank you very much for your support. I am grateful to you

@@RafiqulIslam-dv9cu You're welcome

Hi Christos, what minute of the video are you referring to? You might like to check this out too ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RV47yX70NN8.html

@@AccessAnalytic Thank you very much for the reply, but I still do not understand/recognise what is the environment that you build or start the table ... Is it excel? ....it might be; but probably the menu is in a form that helps you and I really can't follow what and most importantly where you are doing it.....These collapsing menus are very confusing....I am a heavy excel user to lift any doubts about my skills, but do not know how to use DAX and most importantly where to find it..... Is it in excel, is it somewhere else? Like when you build a macro then with vba language (...... so dax is a language ....) you edit this macro in the vba editor by pressing Alt+F11 (....so DAX lives in ..... and you can call it with......). For example in this video at 4:17 is this excel?? sorry I can't say ......(thank you very much for the curtesy to sent me on other video, but didn't help either). T

@@christoslefkimiotis9889 DAX is written and stored in the Data Model - this is known as Power Pivot in Excel. Watch from 2:16 as I load my data into the Excel data model. DAX can then be written either via Right-Clicking in the Pivot Table fields panel or via the Power Pivot Addin that will appear after you click the Green Manage Data Model button on the Data menu. DAX is also written against the Data Model in Power BI desktop. Hope that helps

@@AccessAnalytic Thank you very much for the reply and the infos, but I realize that you are some steps ahead from what I need or probably I need to go a few steps back (what is power pivot, data model and understand many of the unknown words that you used). Thank you for the effort (honestly).

@@christoslefkimiotis9889 - hopefully this playlist will help ru-vid.com/group/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

If you are asking for my reference for an advance DAX course then online the best one is www.sqlbi.com/p/mastering-dax-video-course/ In person in Perth: accessanalytic.com.au/training/courses/data-analysis-courses/dax-data-modelling-power-bi/

tell all your friends 😃

@@AccessAnalytic I do share your channel to my colleagues!!!! 🔥❤️🔥

Fantastic - thanks!