Learn the fundamentals of DAX expressions in Power BI in just 10 minutes.
🔥 Check out Ahrefs Webmaster Tools for FREE here: ahrefs.com/awt
🆓 DOWNLOAD the FREE dataset for this video: view.flodesk.com/pages/641dbeaaa6bca6c87f22ef4a
LEARN:
🔥Power BI for Business Analytics: careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: careerprinciples.com/courses
In this Power BI DAX tutorial, you learn how to use DAX (data analysis expressions) step by step.
Once we've uploaded the dataset into Power BI, we can start with the expressions. In total, we cover 8 types of expressions. We also cover the difference between a measure and a calculated column. First, we do a simple SUM, then we do a DISTINCTCOUNT, followed by a measure with. multiple functions. Fourth, we use the DIVIDE function, which accounts for divided by zero errors.
Then, we hop into the data view to use calculated columns to calculate the profit and profit margin. Then, we use logical functions like an IF, and a nested IF statement to categorize values. Finally, we use the CALCULATE function to find the revenue filtered by beverage brand.
SOCIALS:
🎬 My Company YouTube Channel: youtube.com/@careerprinciples
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑💻 LinkedIn - linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:40 - SUM Function
1:49 - DISTINCTCOUNT
3:00 - Multiple Functions
3:51 - DIVIDE
6:00 - Concatenate
7:34 - IF Function
8:48 - Multiple IFs
9:54 - CALCULATE
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
- Learn DAX Fundamentals in 10 Minutes | Step-by-Step Guide ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- Power BI DAX Tutorial - Beginner to Advanced [Full Course] ( Download)
- Learn DAX by doing! ( Download)
- DAX Basics: Filter CONTEXT & Calculate | Power BI Part 1 #PowerBI #design #shorts ( Download)
- Master Power BI Essentials in Just 15 minutes ( Download)
- Power BI Tutorial in 10 Minutes | Get Started Now! ( Download)
- Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) ( Download)
- What! We don't need to learn DAX anymore (New Power BI Feature) ( Download)
- Making DAX Easy ( Download)
- Your first 10 minutes of Power BI - A no-nonsense getting started tutorial for beginners ( Download)
- [[ 1 HOUR ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - Full Course by Satyajit ( Download)
- Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!) ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
