Channel: Leila Gharani

Category: Education

Tags: excel tips and trickscalculate functiondax calculate functionmicrosoft excel tutorialspower biexcel for analystspowerbimicrosoft excelpowerpivotpower pivotxelplusvisleila gharaniadvanced excel tricksexcel 2016excel 2019xelplusmicrosoft 365excel 2013excel online courseexcel 365daxcalculateexcel tutorialspower bi calculate

Description: Get Access to the Course: courses.xelplus.com/p/master-power-pivot-dax The CALCULATE function is THE most powerful function in Excel Power BI and DAX. Many struggle with this function and get frustrated because it's difficult to picture what's going on. In this video I'm going to explain CALCULATE in simple terms and with a single word! I use Excel and do the explaining with a Pivot Table (Power Pivot), but the same concept applies to Power BI as well. 00:00 CALCULATE in DAX Explained in Simple Terms 00:38 What the CALCULATE Function Does 04:01 How the CALCULATE Function Works 07:45 How to Master DAX and Data Modelling in Excel 🌍 My Online Excel Courses ► xelplus.com/courses ⯆ Complete article on DAX CALCULATE: xelplus.com/dax-calculate-function 🎬 LINKS to related videos: - Excel Productivity for Lazy (but Smart) People: youtu.be/Gf4HmkR7_FE - Hidden Tips in Excel Power Pivot: youtu.be/xxtONTBrvNE 🎒 Get the Official XelPlus MERCH: xelplus.creator-spring.com 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: xelplus.com/course-quiz 📚 Excel RESOURCES I Recommend: xelplus.com/resources 🎥 GEAR I use: xelplus.com/resources/#gear More resources on my Amazon page: amazon.com/shop/leilagharani Let’s connect on social: Instagram: instagram.com/lgharani Twitter: twitter.com/leilagharani LinkedIn: at.linkedin.com/in/leilagharani Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel #dax