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...
Смотрите видео When To Use The CALCULATABLE Function - DAX Function Techniques онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Enterprise DNA 30 Апрель 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 60,067 раз и оно понравилось 631 людям.