CALCULATE vs CALCULATETABLE | Understand the difference + Real World Example
In this video, we explain CALCULATE vs CALCULATETABLE functions in DAX, where we show the difference between CALCULATE vs CALCULATETABLE. We start with the basics and how the CALCULATE differs from CALCULATETABLE and then we proceed to show a real life example, where we calculate the number of new customers acquired everyday for our store.
⭐Watch my previous DAX videos:
Filter Context vs Row Context in DAX: • Filter Context and Row Context in DAX...
CALCULATE function in DAX: • CALCULATE function in Power BI DAX Be...
Download Example Files:
https://tinyurl.com/2t9b3kdv
Timestamps:
00:00 Introduction
00:46 Showing the Data Model
01:18 CALCULATE vs CALCULATETABLE - The Basics
06:17 Calculating the number of new customers acquired every day using CALCULATETABLE
16:24 Conclusion
Sign up for our Newsletter:
https://tinyurl.com/mr33kcsd
Follow us on Social Media:
Facebook: https://tinyurl.com/254eut6z
Twitter: https://tinyurl.com/ycxkjzkk
LinkedIn: https://tinyurl.com/ycym2nee
Instagram: https://tinyurl.com/3mdpbdwa
TikTok: https://tinyurl.com/p36wae4k
Telegram: https://tinyurl.com/escuvwj9
Website: https://tinyurl.com/twtnwuv9
****My online Courses****
https://www.excelbonanza.com/courses/
#dax #powerbi #CALCULATEFUNCTION #calculate
