TAME the the beast that is DAX in Power BI (aka how to learn DAX)

We know that DAX, in Power BI, can be intimidating. We've been there. Patrick shows you how you can learn DAX using what you have available today and TAME the beast that is DAX!


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #DAX #GuyInACube

[nickdoy]

I feel like Dax functions follow the pareto principle in that around 20% of the functions are used 80% of the time. That being said, maybe a follow up video on your 20% to learn right out of the gate as a sign post would help a lot of people out. Certainly Calculate will be in there. Great video Patrick!

[RevusDeonauth]

Patrick, your videos have been an immense help over the years, thanks. Please continue to make more!

[danmeiss]

Great video Patrick. I love these “teach you how to learn” style videos mixed in with the straight forward “here’s how this feature works” style ones.

[ShabnamKhan-vkfj]

This is exactly what I have been looking for all these days- for someone to put it all together for me. Sure, we can learn all the bits and pieces here and there but no one tied the strings together like you did in this video. This is awesome, thanks so much for the tutorial!

[shaunwthompson]

Your videos always help out! This one was exceptional; I have been underutilizing DAX Studio and now I'm going to keep it up all the time to work through problems. Amazing; thanks!

[Griz]

The ability to visually see the output of tables in DAX studio as one iterates through their DAX formula was a game changer for me in terms of learning DAX, great stuff!

[dinoben]

It definitely was a great help to have a showcase of the iterative process of a DAX measure creation. I usually directly write the statement in Power BI without understanding what happens behind the scene. I tend to under-utilize DAX Studio and now I will start having the habit of using it more. Thank you for the knowledge sharing!

[chrismengel]

Another great example of how to use the tool to help you use the tool. Love it! Have started playing with DAX Studio, but this is the first video that illustrates HOW to use it. DAX Guide is no joke - excellent resource for learning and frequently used bookmark (as is Guy In A Cube!). Keep up the great work!

[timbader]

Brilliant video Patrick!
Been catching up on a few of your videos recently and they're all really good - and this one was even better!
I learned to treat DAX like SQL (or any other language, for that matter) and to start small and build up your query from there. Great tip about using a test dataset too.

[jaimederks]

Thanks for this example Patrick, It's really a gift how you can explane and put a smile on my face every single time! You tamed the DAX beast a bit more for me thanks again.

[sue_bayes]

Love this work flow and the use of a small dataset and then iterating through using DAX Studio. Big thumbs up

[dilipwarrier]

Really this cleared lots of hurdles in learning to write DAX functions. Thanks a lot, Patrick! God Bless you!

[TejNarayanan]

WOW.. too good Patrick, that's what I was searching for!! Thanks

[nixb]

Patrick you are awesome! Thank you for all your amazing videos.

[BarnabyWaights]

Fantastic, thanks ! I’m so used to excel where you can (more easily ) verify your outputs and iterate quickly.
I see now I need to get into DAX studio properly!

[amolbdesai]

Great Video Patrick!!!
I loved the three step approach of learning how to learn the functions. 👍

[gkool]

So grateful for this video. Major Big up and respect Patrick and Adam

[rachelrdyer]

Great video Patrick, passing it on to lots of other people. Thanks!

[johnadair]

Totally cool...especially at the end with &" /3" to make it appear as a fraction instead of trying to make it an actual fraction. Brilliant.

[DJ_Q]

I've been watching Guy In a Cube for a few days now.
When I noticed the problem where the December date was returned, EOMONTH(<date>, 0) came to mind. Then when I saw you type it... I felt so smart.

The COALESCE function has also been of great use to me.

Thank you for what you guys do. You have earned a subscriber.