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)
- Learn DAX by doing! ( Download)
- Making DAX Easy ( Download)
- No More DAX Power BI’s NEW Feature Explained (File Included) ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Power BI DAX Tutorial - Beginner to Advanced [Full Course] ( Download)
- What! We don't need to learn DAX anymore (New Power BI Feature) ( Download)
- Tips and Tricks to make learning DAX a bit Easy! ( Download)
- Will Artificial Intelligence Make Learning DAX Obsolete | Power BI ( Download)
- DAX! Uggg - Where do you start | Power BI ( Download)
- [[ 3 HOURS ]] Complete Power BI DAX End to End - Power BI DAX Tutorial - { End to End } Full Course ( Download)
- Learn These 10 Functions First to Learn DAX for Power BI #shorts ( Download)
- TAME the the beast that is DAX in Power BI (aka how to learn DAX) ( Download)
- Learn Power Pivot & DAX for Power BI with 20 Beginner to PRO Examples (Sample file included) ( Download)
