How To Use The INTERSECT Function - Power BI & DAX Tutorial

The INTERSECT function in Power BI can seem to be a little confusing. In this tutorial, I'll walk through what it is and how you can use it for more advanced Power BI analysis. There are many applications for using the INTERSECT function and they only really become obvious once you can gain a deeper understanding of virtual tables (of which INTERSECT can create). Enjoy! ****Video Details**** 0:55 - Sample report showcasing customer data 2:37 - finding out repeat customers using INTERSECT function 6:40 - using INTERSECT in a different context 8:04 - working out the total sales from repeat customers 8:36 - calculating customers with three months order transactions ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE – 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ *****Related Links***** How To Understand Virtual Tables Inside Iterating Functions In Power BI - https://blog.enterprisedna.co/how-to-understand-virtual-tables-inside-iterating-function-in-power-bi-dax-concepts/ Deep Dive Into RANKX – DAX Formula Concepts In Power BI - https://blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/ Implementing DAX Measure Groups Into Your Power BI Reports - https://blog.enterprisedna.co/implementing-dax-measure-groups-into-your-power-bi-reports-modeling-review/ *****Related Course Modules***** Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations Ultimate Beginners Guide to DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax Advanced Analytics in Power BI - http://portal.enterprisedna.co/p/advanced-analytics *****Related Forum Posts***** How To Use The INTERSECT Function - Power BI & DAX Tutorial - https://forum.enterprisedna.co/t/how-to-use-the-intersect-function-power-bi-dax-tutorial/749 Confirming My Understanding of INTERSECT - https://forum.enterprisedna.co/t/confirming-my-understanding-of-intersect/3868 INTERSECT And Except - https://forum.enterprisedna.co/t/intersect-except/4958 For more INTERSECT function queries to review see here - https://forum.enterprisedna.co/search?q=INTERSECT%20function