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)
- Power BI + Excel = Great DAX!!! ( Download)
- How and where to write DAX Measures for Power BI and Excel ( Download)
- DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- DAX CALCULATE Function Made Easy to Understand (just one word) ( Download)
- Main Difference Between DAX and Excel Formulas in Power BI ( Download)
- No More DAX Power BI’s NEW Feature Explained (File Included) ( Download)
- 5 Essential DAX Functions Every Power BI User Should Know #powerbi #excel #data ( Download)
- Full Free DAX Class: Fundamentals of DAX in Power BI & Power Pivot. 365 MECS Class 17 ( Download)
- Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!) ( Download)
- Beginner Power BI DAX Functions Tutorial [Full Course] ( Download)
- What! We don't need to learn DAX anymore (New Power BI Feature) ( Download)
- Power BI Tutorial for Beginners ( Download)
- Main Difference Between DAX & Excel Formulas - (1.8) Ultimate Beginners Guide to DAX 2020 ( Download)