Learn 80% of DAX in an Hour (with FREE sample file)

Want to learn DAX but don't have the time? This is the video for you. In this one-hour masterclass, learn the 80% essential DAX with practical examples. Understand and master concepts like: → How to create measures 🤔 → Measure vs. Column ⚙ → Measure reusability ♻ → Evaluation Context 💻 → Basic DAX functions - SUM, COUNTROWS, AVERAGE, DIVIDE 🧮 → Conditional DAX functions - IF 🌿 → Understanding and using CALCULATE function 📗 → Multiple filters with CALCULATE 🥝 → How to get good with DAX using ACMBU technique 💡 📁 Download practice workbooks: ============================= Blank Power BI file (with data model + data) - https://chandoo.org/wp/wp-content/uploads/2024/10/powerbi-data-model-done.zip (unzip this) Sample dataset - https://chandoo.org/wp/wp-content/uploads/2024/10/sample-chocolate-sales-data-all.xlsx Completed Power BI file (and rest of the videos + files) - https://chandoo.org/wp/free-data-analyst-course/ ⏱ Video Chapters: ================ 0:00 - Introduction to DAX & our data model 3:00 - Our first DAX measures 11:24 - Why we need DAX when you can get the same thing with "auto" calculations 13:18 - DAX Pledge (say it out with me 🗣) 13:39 - Measure vs. Columns 15:08 - More DAX formulas 16:08 - Difference between Excel and DAX functions! 19:24 - Understanding Evaluation Context 25:12 - Reusing DAX measures 28:32 - Why not use table name in the measures? 30:56 - DIVIDE function 34:18 - CALCULATE function 42:21 - More than one filter with CALCULATE() 46:35 - IN operator 49:22 - Conditional logic with IF() 52:51 - Measures are SCALAR (Aggregates) 55:29 - Awesome DAX trick 💡 58:20 - ACMBU Technique for Better DAX 😎 👩‍💻👨‍💻 Join my Power BI Course ========================== Want to master all aspects of Power BI - right from Power Query to Data Modeling to Power Pivot to DAX to Visual design to Report building? Then you are going to LOVE my Power BI Course. Trusted by more than 1000 people all over the world and consistently rated 5* by everyone. Check out the program and sign up today. Go here 👉 https://chandoo.org/wp/power-bi-course/ 📺 More Power BI Videos on my Channel: ================================= Previous concepts: Data modeling: https://youtu.be/4ePNrdxWtY0 Introduction to Power BI: https://youtu.be/al4OfLIOl2w Introduction to Power Query: https://youtu.be/MMdcczmULrU Power BI Jargon Explainer - https://youtu.be/mO-fvZPg7-Q Power BI Jargon Explainer (part 2) - https://youtu.be/6eQL_GnFXls VIDEOS: Power BI Sales Dashboard in an hour - https://youtube.com/live/mXD0Peot4hY?feature=share Data analysis with Power BI (end to end live) - https://youtube.com/live/8tfcVnoEL0c?feature=share Power BI end-to-end Course - https://youtu.be/uwe8C7K8fXY Power BI + SQL how to - https://youtube.com/live/UQJAHUUFK-o?feature=share How to use DAX (another video, just as awesome) - https://youtu.be/PQ5lALdFHCU Complex Power BI Dashboard (end to end tutorial) - https://youtu.be/ooJO7NW4uJU Power BI Playlists: FREE Power BI Course - https://www.youtube.com/playlist?list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo Power BI tips & examples - https://www.youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs Power BI DAX - https://www.youtube.com/playlist?list=PLmejDGrsgFyCm0i58VobdriBr--FA8lYh Power BI Power Query - https://www.youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2 COURSES: Power BI - https://chandoo.org/wp/power-bi-course/ Adv. Excel - https://chandoo.org/wp/excel-school-program Complete DATA Analysis course (Sql, Power BI, Excel, Python) - https://chandoo.org/mdac ~ CALCULATE(), FILTER() and ALL() wanted to have dinner together. But it never happened. Why? Because FILTER() kept excluding people ALL kept ignoring everything and CALCULATE as usual was late 😂 #Powerbi #dax #chandoo #freedataanalystcourse #fdac