Calculating New & Existing Customer Sales Using DAX in Power BI - Advanced DAX

Seriously awesome attrition type analysis using DAX in Power BI to discover how much new customers are contributing to sales. I really break it down into it's simplest form here and even show you how to make this calculation dynamic! This techniques really showcases how amazing DAX is as an advanced analytical language. ***** Video Details ***** 2:08 - creating date table 2:38 - new customer sales 7:00 - existing customer sales 7:33 - visualising the data ***** 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 - https://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 ***** Discover How Many Sales Can Be Attributed To New Customers – Advanced Power BI Insights - https://blog.enterprisedna.co/discover-how-many-sales-can-be-attributed-to-new-customers-advanced-power-bi-insights/ Calculate The Total Of New Clients You’re Onboarding Every Month – Advanced DAX - https://blog.enterprisedna.co/calculate-the-total-of-new-clients-youre-onboarding-every-month-advanced-dax/ Discover What Was The Initial Product A Customer Purchased Using DAX - https://blog.enterprisedna.co/discover-what-was-the-initial-product-a-customer-purchased-using-dax/ ***** Related Course Modules ***** Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations Advanced Analytics in Power BI - http://portal.enterprisedna.co/p/advanced-analytics Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios ***** Related Support Forum Posts ***** Reasons For Employee Attrition - https://forum.enterprisedna.co/t/reasons-for-employee-attrition/4463 Complicated Data - https://forum.enterprisedna.co/t/complicated-data/4548 Analytics Feature For Combo Chart - https://forum.enterprisedna.co/t/analytics-feature-for-combo-chart/4167 For more advanced analytics support queries to review see here…. - https://forum.enterprisedna.co/search?q=advanced%20analytics