What is DAX in Power BI? Explained with Real Examples | DAX Tutorial #4

What is DAX in Power BI? In this video, I have explained DAX with super simple real-life examples - No boring theory! If you know how to calculate a supermarket bill, you already know DAX! WHAT YOU WILL LEARN: Raw Data vs Information Real Life DAX Examples: Supermarket Bill, Instagram Logic, Classroom Topper Row Context vs Filter Context CALCULATE Function - The BOSS of DAX 10 DAX Formulas Live: 3 Calculated Columns + 5 Measures + 2 Dashboard KPIs PRACTICE DATASET Free: Download: https://docs.google.com/spreadsheets/... - 500 Rows, 3 Sheets - Sales, Products, DateTable 10 DAX FORMULAS COVERED: Total Cost = Qty * UnitCost Profit = Final Sales - Total Cost Order Type = IF Final Sales greater than 50000 then High Value else Low Value Total Sales = SUM Sales Final Sales Total Profit = SUM Sales Profit Profit Percent = DIVIDE Total Profit, Total Sales, 0 Total Orders = COUNTROWS Sales Avg Sale = AVERAGE Sales Final Sales YTD Sales = TOTALYTD Total Sales, DateTable Date Electronics Sales = CALCULATE Total Sales, Category equals Electronics NEXT VIDEO: Data Modeling and Relationships in Power BI | Star Schema Explained 5 TIMESTAMPS: 00:00 Intro and Why DAX is Important 01:30 What Actually IS DAX 03:00 Example 1 Supermarket Bill 05:00 Example 2 Instagram Logic 06:30 Example 3 Classroom Result - Row vs Filter Context 08:00 CALCULATE Function Explained 10:00 Live 10 DAX Formulas Full Power BI Playlist: Add Your Playlist Link Here Channel: Coding By Shailja - Learn, Build, Grow! Keywords: what is dax in power bi, dax tutorial for beginners, power bi dax tutorial, dax formulas in power bi, row context vs filter context, calculate function in power bi, totalytd dax, power bi tutorial for beginners, learn dax, power bi dax explained, dax real life examples 3. HOMEWORK QUESTIONS Q1. What is the Total Profit for all orders? Q2. How many orders are there in the West Region only? Q3. Which Category gives more Profit - Electronics or Furniture? Q4. Create a new column Profit Margin Percent Per Order equals DIVIDE Profit, Final Sales, 0 and find highest margin order. Q5. Create YTD Sales measure. If it shows blank, what is the mistake? Hint: Check relationship between Sales and DateTable. 4. HASHTAGS - Under 500 Characters PowerBI, PowerBIDAX, DAXTutorial, WhatIsDAX, DAXFormulas, PowerBIForBeginners, LearnPowerBI, PowerBITutorial, DataAnalytics, BusinessIntelligence, DAXExplained, CALCULATEFunction, MicrosoftPowerBI, CodingByShailja, PowerBIDesktop