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!

@AccessAnalytic

2 жыл бұрын

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.

@marcdoeseverything

2 жыл бұрын

@@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 :)

@AccessAnalytic

2 жыл бұрын

@@marcdoeseverything My DateTable video should help kzread.info/head/PLlHDyf8d156VDobBIk13o4mZLk19DbV81

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.

@AccessAnalytic

Жыл бұрын

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!

@AccessAnalytic

9 ай бұрын

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.

@AccessAnalytic

2 жыл бұрын

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.

I have a perfect use case for this. Thanks, Wyn.

@AccessAnalytic

Ай бұрын

Great!

Basic and deep explanation at the same time. Thank you Wyn!

@AccessAnalytic

2 жыл бұрын

Cheers Iván

Super concise! Fully appreciate the time, effort and planning in making this short and understandable for beginners.

@AccessAnalytic

2 жыл бұрын

Thank you very much for the kind comment

This is one of the best explanation of basics of DAX I have seen !! Thank you Sir.

@AccessAnalytic

2 жыл бұрын

Thanks Lorenzo, very kind of you to say so

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!!

@AccessAnalytic

2 жыл бұрын

Thanks as always for your support Wayne

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.

@AccessAnalytic

Жыл бұрын

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

@osoriomatucurane9511

5 ай бұрын

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

@AccessAnalytic

Жыл бұрын

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

This was very educative, I saw Excel in a new light in relation to DAX formulas. You did a great job, thank you. 😇

@AccessAnalytic

Жыл бұрын

You're very welcome!

Hi Sir, Your Explanation is good. You said The root of Dax comes out.

@AccessAnalytic

Жыл бұрын

Thank you

Very good explanation with easy to track and easy-to-understand examples. Thank you very much 🤝👌

@AccessAnalytic

2 жыл бұрын

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

Amazing as always !

@AccessAnalytic

3 ай бұрын

You’re welcome

Fantastic demo using the concept you chose as example, thank you :)

@AccessAnalytic

Жыл бұрын

You’re welcome

Thanks Wyn. This was helpful for me, for sure. 🙏

@AccessAnalytic

9 ай бұрын

Great! Glad to help

I like the way you explain the subject of DAX. Thank you ...

@AccessAnalytic

2 жыл бұрын

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

It does help a lot .. you made it so simple to understand!

@AccessAnalytic

Жыл бұрын

Thank you

Thanks for the simple explanation Wyn

@AccessAnalytic

2 жыл бұрын

No worries, thanks for leaving a comment

Thank you very much. I found it very helpful

@AccessAnalytic

2 жыл бұрын

Thanks for letting me know 😀

I thank you and I appreciate u makin this video Sir. Thank you...Subscribed!

@AccessAnalytic

2 жыл бұрын

That’s great Ayanda. Welcome to the channel

Hope to find more simplistic videos like this in your channel

@AccessAnalytic

2 жыл бұрын

Check out my “getting started” playlist kzread.info/head/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

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! :-)

@AccessAnalytic

2 жыл бұрын

Thanks Geert, greatly appreciated. I have a “Getting Started” playlist kzread.info/head/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

It is definitely useful. Thanks

@AccessAnalytic

2 жыл бұрын

Thanks for letting me know Krishna

Nice explanation👍

@AccessAnalytic

3 ай бұрын

Thanks

Awesome 👍

@AccessAnalytic

2 жыл бұрын

Thanks 😃

Thank you !!

@AccessAnalytic

Жыл бұрын

You’re welcome

Great thanks

@AccessAnalytic

11 ай бұрын

You’re welcome

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?

@AccessAnalytic

Жыл бұрын

Ctrl and mouse wheel 😀

@JeanneLee-ix8vl

Жыл бұрын

@@AccessAnalytic Thank you😄

@AccessAnalytic

Жыл бұрын

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!

@AccessAnalytic

Жыл бұрын

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.

@Janet2801

Жыл бұрын

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

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?

@AccessAnalytic

2 жыл бұрын

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

thanks

@AccessAnalytic

Ай бұрын

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

@AccessAnalytic

2 жыл бұрын

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

@elicreedy6596

2 жыл бұрын

@@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!

awesome

@AccessAnalytic

Жыл бұрын

Thanks 😊

very useful

@AccessAnalytic

2 жыл бұрын

Thanks

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

@AccessAnalytic

Жыл бұрын

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

@RafiqulIslam-dv9cu

Жыл бұрын

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

@AccessAnalytic

Жыл бұрын

@@RafiqulIslam-dv9cu 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?

@AccessAnalytic

2 жыл бұрын

Hi Christos, what minute of the video are you referring to? You might like to check this out too kzread.info/dash/bejne/hIpomduRZ5O0fps.html

@christoslefkimiotis9889

2 жыл бұрын

@@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

@AccessAnalytic

2 жыл бұрын

@@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

@christoslefkimiotis9889

2 жыл бұрын

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

@AccessAnalytic

2 жыл бұрын

@@christoslefkimiotis9889 - hopefully this playlist will help kzread.info/head/PLlHDyf8d156Wh6gpMGyQ4pZ72x3EQhv9P

Advanced dax course?

@AccessAnalytic

2 жыл бұрын

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 🔥

@AccessAnalytic

Жыл бұрын

tell all your friends 😃

@mandypaulissen

Жыл бұрын

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

@AccessAnalytic

Жыл бұрын

Fantastic - thanks!