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...
Watch video When To Use The CALCULATABLE Function - DAX Function Techniques online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 30 April 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 60,067 times and liked it 631 visitors.
