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 - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/

*****Related Links*****
How To Understand Virtual Tables Inside Iterating Functions In Power BI - 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 - blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/
Implementing DAX Measure Groups Into Your Power BI Reports - blog.enterprisedna.co/implementing-dax-measure-groups-into-your-power-bi-reports-modeling-review/

*****Related Course Modules*****
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Ultimate Beginners Guide to DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
Advanced Analytics in Power BI - portal.enterprisedna.co/p/advanced-analytics

*****Related Forum Posts*****
How To Use The INTERSECT Function - Power BI & DAX Tutorial - forum.enterprisedna.co/t/how-to-use-the-intersect-function-power-bi-dax-tutorial/749
Confirming My Understanding of INTERSECT - forum.enterprisedna.co/t/confirming-my-understanding-of-intersect/3868
INTERSECT And Except - forum.enterprisedna.co/t/intersect-except/4958
For more INTERSECT function queries to review see here - forum.enterprisedna.co/search?q=INTERSECT%20function

• How To Use The INTERSECT Function - Power BI & DAX Tutorial ( Download)
• Intersect Function in Power BI Dax ( Download)
• INTERSECT - DAX Guide ( Download)
• Intersect function DAX | Power BI ( Download)
• Power BI DAX Tutorial | UNION | INTERSECT | EXCEPT in DAX ( Download)
• CONTAINSROW() vs. INTERSECT() Power BI DAX Functions: Pros and Cons and When to Use ( Download)
• Power BI INTERSECT function ( Download)
• INTERSECT function (DAX) - DAX INTERSECT function in Power BI Part1 ( Download)
• Set functions in DAX UNION, INTERSECT, and EXCEPT ( Download)
• Power BI DAX Tutorial (23/50) - What is UNION Intersect Except in DAX ( Download)
• HOW TO USE INTERSECT FUNCTION IN POWER BI || DAX INTERSECT || #powerquery #powerbi #powerautomate ( Download)
• DAX Language - INTERSECT Function in Power BI ( Download)
• Joins in Power BI (3/4) | Intersect Function in Power BI ( Download)
• Combining Tables in Power BI Union Except and Intersect in DAX ( Download)
• DAX Sketches w/ Brian Grant: An intro to the INTERSECT Function ( Download)