📊 How to use Power BI DAX - Tutorial

In this step-by-step tutorial for beginners, learn how to use DAX (Data Analysis Expressions) in Microsoft Power BI. DAX is a formula language with functions. If you've ever written formulas in Excel, you'll find that DAX is very familiar.

We'll start by loading the sample data into a data model. Next, we establish relationships between the various tables.

Once the setup is complete, we'll write our first measure. A measure is a calculation that runs across our data model. You'll learn about a few different functions, including sum and count. You'll also learn how to comment your expressions.

Next, we create a measure using operators, like addition, subtraction, division, and multiplication. We then dive into how you can create measures using a graphical user interface called Quick Measures.

We then move onto creating a calculated column and talk about the advantages and disadvantages of columns vs. measures.

We then dig into iterator functions and when you would use them compared to an aggregator function. Iterator functions include sumx, countx, averagex, maxx, minx, and rankx.

Next, we look at the date functions that are available and we use the one called weekday.

We wrap up by looking at some logical functions, including find, if, and calculate.

👋 Additional resources

⌚ Timestamps
0:00 Introduction
0:49 Import data & create data model
3:25 Define relationships
5:14 Create new measure using sum function
10:22 Format measures
11:44 Edit & delete measures
12:33 Create new measure using count function
14:30 Create new measure using distinct function
16:02 Add comments to measures
16:56 Create new measure with operators
19:08 Quick Measure tool
20:36 Create calculated column
21:38 Measure vs. calculated column
22:07 Measure that references another measure
24:19 Iterator functions
27:32 Time & date functions
30:12 Find function
32:38 If function
33:54 Calculate function
36:39 Wrap up

📃 Watch related playlists

📩 NEWSLETTER

🚩 Connect with me on social

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert

[walkernationz]

Today I went to a work interview (Thursday). They asked me if I was good on Power BI, and I never heard about it before. They said they could get around it, but I said I would be able to master it by Monday. Your videos popped up on my search and as I followed them, I feel like I'm ready in just one day. Really nice, powerful and simple at the same time program. Thanks to your tutorials, the introduction to this program was easy for me. Keep up with these videos. You will be the first search going on from here for software tutorials for me.

[joanneosborne]

Kevin, you are such a great teacher. 🤩Thank you for keeping it very simple and clear. I love the way you explain everything and I am excited to watch more of your training videos for DAX. I have found Dax hard to learn but you make it fun and exciting. 😀

[nevkarngutor]

What a great teacher. You just made DAX look less of a mystery to me. never thought I will take on DAX and be this happy. Thank you Kevin. God bless you Sir

[carelkawele]

Kevin, I just started a job at an accounting firm and we use Power BI as a tool during audits. This is amazing really. Great work explaining every step, it's extremely helpful!

[blushstix]

It's The way you've explained just makes me wanna learn more. We need more videos on DAX please!

[michelleliu]

Thanks very much for this! It's been a while since I last used Power BI DAX functions and needed a refresher. Your video turned out to be so much better than what I had initially expected! I hope you can do more tutorials on complicated DAX, they used to give me so much headaches!

[corporatemonks]

This is fantastic, I had basic idea about power BI and DAX... but this video helped me to get into detail on calculation part... It was easy to understand and learn. Thanks a lot 🙂

[nielporter]

Kevin, this instruction is awesome. I'm pretty new to Power Bi but I've been performing data analysis for a long time. Your instruction touched on many topics that quickly made sense to me (leveraging my previous experience with Excel) and the examples (following along with your example files) cleared up any questions I had. I only wish I had Power Bi 30 years ago (yes, I'm old). Thank you.

[petruswahjudi]

Kevin, you are a great teacher. You explain very details and clear.
Thank you for sharing your knowledge.

[gajabathiarjuntg]

I am absolute beginner in Power BI Dax formulas. But now by watching this video I understood how to use them and about their core functionalities. Thanks Kevin great effort.

[manhthinhbui]

Kevin, you are such a great teacher!

I've spent 3 months learning from some other guys on Youtube and doesn't understand anything. But your 37-min video just changed anything, I could understand a bit more on how star scheme, DAX, new colume, measure, ... works. That's just great!

[kemadx]

Nice video. Very descriptive with good examples. I would have loved it if, when you were doing % and margins, you showed how big a % of total profits each customer was. So the customer profit % of total profit, and in the same table. That would have been a great real world addition 😊

[Shazlys]

This was awesome!! We need more advanced Power BI videos.

[shoaibazizmeer]

Hey Kevin! Now I finally understand the difference between aggregate functions and iterate functions. Two thumbs up to you.

[jasminjavia]

Each time I saw your tutorials...I end up watching your video by saying you a big thank you from the bottom of my heart...it is really helpful Kevin...you are truly great teacher...thanks once again.

[karthikganapathy]

Thanks a lot Kevin! I keep coming back here for the DAX measures using your cookie examples. Makes it so easy to understand. Power to you!

[braunmar]

Really useful, thank you!! I like that I can follow along with the sample files real time. Love the format!

[marcusmacmillan]

Thank you so much Kevin! I have been struggling a bit with some of these concepts in DAX and this has made everything so much clearer for me. I can't wait to go back and rewrite some of my old measures and create new more powerful ones, especially with the Calculate Function.

[marymurathi]

Kevin you are just amazing ! Thank you so much for profound and comprehensive tutorial. I'm grateful

[TomiwaAdegbola]

This video summarizes what took me 1 month to learn from DAX pdf book. Great work Kevin! Thanks for this!