When To Use The CALCULATABLE Function - DAX Function Techniques

Watch the 2022 Update of this video here: When To Use The CALCULATETABLE Functi...

CALCULATETABLE can be a mind-bender when you're just starting out with Power BI. In this video tutorial, I look to cover the main ways you need to think about this particular function and how to use it in Power BI.

Good luck with this one.

***Video Details***
4:17 - calculating new customers using CALCULATETABLE
6:20 - evaluating a customer set
6:51 - adding a FILTER function
8:27 -  calculating lost customers using CALCULATETABLE
8:43 - adding the EXCEPT function


**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...


****Related Links****
How To Understand Virtual Tables Inside Iterating Functions In Power BI - https://blog.enterprisedna.co/how-to-...
Deep Dive Into RANKX – DAX Formula Concepts In Power BI - https://blog.enterprisedna.co/deep-di...
Implementing DAX Measure Groups Into Your Power BI Reports - https://blog.enterprisedna.co/impleme...


****Related Course Modules****
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
Learning Summit Series - https://portal.enterprisedna.co/p/lea...
Advanced Analytics in Power BI - http://portal.enterprisedna.co/p/adva...


****Related Forum Posts****
Advanced Table Functions: CALCULATETABLE - https://forum.enterprisedna.co/t/adva...
Calculate Table - Subset Based On Unique Column Values - https://forum.enterprisedna.co/t/calc...
Lost Customers Calculation - https://forum.enterprisedna.co/t/lost...
For more calculatetable queries to review see here - https://forum.enterprisedna.co/search...

• #science_technology
• #enterprise_dna
• #sam_mckay
• #power_bi
• #dax
• #powerbi
• #dax_tutorial
• #power_bi_tutorial
• #power_bi_desktop
• #dax_power_bi
• #power_bi_time_intelligence
• #power_bi_dax
• #how_to_learn_dax
• #learn_power_bi
• #power_bi_training
• #dax_training
• #time_intelligence
• #data_analysis
• #power_bi_for_beginners
• #excel
• #analytics
• #dashboards
• #data
• #dax_for_beginners
• #advanced_dax
• #calculatetable_dax
• #calculatetable_function
• #calculatetable_example