CROSSJOIN is a DAX function that returns a new table based on the parameters you input into the formula. In this tutorial, Sam runs through the CROSSJOIN function in Power B, and a detailed example of how this can be effectively applied to certain types of analysis as well as other ways that this function can be used effectively.
WATCH THE FULL WORKSHOP SESSION HERE: https://youtu.be/n_Ki8XA4cCY
***** Video Details *****
00:00 Introduction
01:29 Using the CROSSJOIN function
05:42 Using the DISTINCT and SUMMARIZE functions
07:04 Other ways to use CROSSJOIN
***** 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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial