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
- Introduction to Power BI (Start here if you're new to Power BI) - youtu.be/TmhQCQr_DCA
- Sample files (use these to follow along) - 1drv.ms/u/s!AmxrofZZlZ-whMIgS9WJS7BwSfHBbw?e=0z3nQn
⌚ 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
- Playlist with all my videos on Power BI: youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🚩 Connect with me on social
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert/
🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1
🎬 Want to watch again? Navigate back to my YouTube channel quickly
kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ 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
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Power BI DAX Tutorial | How to use DAX functions with Examples | Beginners | Power BI Tutorial ( Download)
- Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
- Power BI DAX Tutorial for Beginners | How to Use DAX Function in Power BI with Examples ( Download)
- How to use DAX in Power BI | Microsoft Power BI for Beginners ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- Power BI DAX Tutorial - Beginner to Advanced [Full Course] ( Download)
- DAX In Power BI Tutorial | Dax For Power BI | Power BI Tutorial For Beginners | Simplilearn ( Download)
- Making DAX Easy ( Download)
- Power BI DAX: How to Use the CALCULATE Function ( Download)
- Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
- Boost your productivity with DAX Query View in Power BI Desktop! ( Download)
- DAX Basics: Filter CONTEXT & Calculate | Power BI Part 1 #PowerBI #design #shorts ( Download)
- [[ 3 HOURS ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - { End to End } Full Course ( Download)
