What is DAX?
Vložit
- čas přidán 30. 06. 2024
- What is DAX and how to write DAX formulas.
How do DAX formulas work?
If you're getting started with DAX, Power BI or Power Pivot in Excel then this is for you
Video I mention that you may want to watch first
DAX and Data Model Introduction video: • DAX and the Data Model
Follow me on LinkedIn
/ wynhopkins
Twitter
/ wynhopkins
Access Analytic Training
accessanalytic.com.au/training - Jak na to + styl
I consider myself an excel gun, but lord have mercy your videos have made me realise how little I know. I just started with PowerBI and it feels like an untapped universe for me, but your videos have made it far less daunting.
Thank you so much for this incredible series!
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 czcams.com/play/PLlHDyf8d156VDobBIk13o4mZLk19DbV81.html
Thank God you exist, man! For whoever thinks she/he knows Excel, this video is a MUST. It's like passing from High-school Math to Calculus at University....You explained it superbly.
Thanks David. Really appreciate you taking the time to leave a kind comment
The way you compare DAX with Excel is very nice. As an Excel user, I now learn DAX a lot easier. At first I found DAX was very hard to understand, as I always had Excel "framework" in my mind. Thanks!
You're welcome, thanks for letting me know it's useful. Yes it's a different way of thinking
Smooth! I once heard "I did not have time to write a short letter so I have written a long one". I really appreciate the time and effort you have put into this short video. I have no doubt it took a long time. With a great deal of thought and maybe even testing before you have posted it. I know there are many hour of video's and pages in books and blogs that have tried to explain Dax to beginners. This is the BEST one! Thanks yet again Wyn.
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.
Basic and deep explanation at the same time. Thank you Wyn!
Cheers Iván
I have a perfect use case for this. Thanks, Wyn.
Great!
Super concise! Fully appreciate the time, effort and planning in making this short and understandable for beginners.
Thank you very much for the kind comment
Thanks Wyn. Understanding what is under the hood really helps. As you said.. tables and filters.. requires rethinking coming from a worksheet and formulas background. Thanks for the explanation and examples.. much appreciated :)) Thumbs up!!
Thanks as always for your support Wayne
This is one of the best explanation of basics of DAX I have seen !! Thank you Sir.
Thanks Lorenzo, very kind of you to say so
Nice intro for a newbie. Thanks. It's a useful insight because a couple of videos on YT are saying that DAX looks a bit like normal Excel functions so it's easy. But that's rubbish...the logic is completely different even if the name of the function is similar. Coming from an Access background more than Excel it's useful to see it a bit like SQL which is all about joining tables and filtering. The other thing is WHERE to put these functions because of course in Excel you just stick a function in a cell. I'm now getting a handle on this data model thing. I'm now primed to do some work on this tomorrow. Cheers.
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!
Love the explanation, made it so much clearer, should have watched this first.thanks
Glad to help Andrew, thanks for taking the time to let me know it's useful
Very good explanation with easy to track and easy-to-understand examples.
Thank you very much 🤝👌
You’re welcome Jayantkumar, thanks for letting me know you liked it
Hi Sir, Your Explanation is good. You said The root of Dax comes out.
Thank you
This was very educative, I saw Excel in a new light in relation to DAX formulas. You did a great job, thank you. 😇
You're very welcome!
Fantastic demo using the concept you chose as example, thank you :)
You’re welcome
I like the way you explain the subject of DAX. Thank you ...
You’re welcome Zuhair, thanks for taking the time to leave a kind comment.
Thanks Wyn.
This was helpful for me, for sure. 🙏
Great! Glad to help
It does help a lot .. you made it so simple to understand!
Thank you
Amazing as always !
You’re welcome
Thanks for the simple explanation Wyn
No worries, thanks for leaving a comment
Thank you very much. I found it very helpful
Thanks for letting me know 😀
Hope to find more simplistic videos like this in your channel
Check out my “getting started” playlist czcams.com/play/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P.html
I thank you and I appreciate u makin this video Sir. Thank you...Subscribed!
That’s great Ayanda. Welcome to the channel
Just watched this video: this kind of videos/explanation is simply essential to teach the beginners the concepts of DAX.
Yes, I’m quite a bit further up the DAX learning curve than this, but your video explains things in easy terms. Not many people succeed in doing that. Did you make an entire series like this? Did you put them in a playlist? I’d be happy to refer to it!
Great job! :-)
Thanks Geert, greatly appreciated. I have a “Getting Started” playlist czcams.com/play/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P.html
Nice explanation👍
Thanks
It is definitely useful. Thanks
Thanks for letting me know Krishna
Awesome 👍
Thanks 😃
Hi Wyn, Great Video, DAX does seem powerful. Although, I have a question. I have a data model that does not show up any links displayed in Diagram view, but if I look at the three tables two have links beside the table names. So I am thinking that these somehow reference the third via DAX. So how could I reveal the DAX used in this case?
Hi, I've just messaged you on LinkedIn to get a screenshot
Thank you for the excellent explanation! Just a little question please, could you tell us how you zoom in the formula bar starting 7:48 in the video?
Ctrl and mouse wheel 😀
@@AccessAnalytic Thank you😄
No worries
Thank you so much for posting these incredible videos! Could you share how did you do the filtering starting 4:59 in the video? Filtering PS4, Wii, switch, etc. I am very new to DAX, sorry to bother you. Thank you!
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!!
Thank you !!
You’re welcome
Hey sir, I had an unrelated question if you don’t mind. Towards the beginning of the video, you had the filters assigned to buttons. How did you do that? Or do you have a video explaining? Thank you for all you do! Your videos are appreciated
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!
Great thanks
You’re welcome
Thank you for your DAX basic video. I am searching this type of video for basic understand of DAX. Now I understand how DAX work. Would you please advise me from where I start to learning DAX . lot's of video I watched but I am set my sequence
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
very useful
Thanks
awesome
Thanks 😊
thanks
You’re welcome.
when you say input a new sheet, where is that. In excel? or somewhere else? What is the environment that you had the table and the dax measures?
Hi Christos, what minute of the video are you referring to?
You might like to check this out too czcams.com/video/RV47yX70NN8/video.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 czcams.com/play/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P.html
Advanced dax course?
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/
You're such a great coach 🫰🏻 that I don't understand why your subscriber number is not high 🔥
tell all your friends 😃
@@AccessAnalytic I do share your channel to my colleagues!!!! 🔥❤️🔥
Fantastic - thanks!