What is DAX?

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

Follow me on LinkedIn

Twitter

Access Analytic Training

[marcdoeseverything]

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!

[davidestradacordova]

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.

[andrewsinha]

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.

[MuhammadFirdaus-tzuq]

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!

[IvanCortinas_ES]

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

[wayneedmondson]

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

[Acheiropoietos]

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

[tagabayugo]

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

[lorenzoladejobi]

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

[WildRover]

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.

[andrewferguson]

Love the explanation, made it so much clearer, should have watched this first.thanks

[jayantkumarjoshi]

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

[royaltemi_]

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

[zuhairalmutawa]

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

[sivareddy]

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

[louism.]

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

[leostar]

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

[cyclingmc]

Hope to find more simplistic videos like this in your channel

[taibabs]

Thank you very much. I found it very helpful

[BenLinfordUK]

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