Watch The 2023 Update Of This Video Here: https://youtu.be/NH_cK5DMtss
It is important to understand the breakdown of your sales between your new customers vs your steady customers.
In this example, I'll show you how to combine a number of DAX functions to achieve this.
This is some advanced Power BI analytics, so I hope from watching this video you can see the unlimited analysis potential you start to have when using Power BI effectively.
****Video Details****
0:42 - sample report for New Customer Analytics
2:24 - identifying your new customers
5:11 - breaking out new customer sales
7:44 - calculating the percentage of new customer sales
8:25 - changing time window dynamically
***** 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 *****
New vs Existing Customers - https://blog.enterprisedna.co/new-vs-existing-customers-advanced-analytics-w-dax/
New Customer Analysis Using Advanced DAX - https://blog.enterprisedna.co/calculate-the-total-of-new-clients-youre-onboarding-every-month-advanced-dax/
Attrition Analysis: Finding Lost Customers Using Power BI & DAX - https://blog.enterprisedna.co/?p=83248
***** Related Course Modules*****
Unique Analytical Scenarios - http://portal.enterprisedna.co/p/unique-analytical-scenarios
Business Analytics Series - https://portal.enterprisedna.co/p/business-analytics-series
Mastering DAX Calculations - https://portal.enterprisedna.co/p/mastering-dax-calculations
***** Related Support Forum Posts*****
Comparing New vs Lost vs Steady Customers over Multiple Years - https://forum.enterprisedna.co/t/comparing-new-vs-lost-vs-steady-customers-over-multiple-years-customer-churn-examples-advanced-dax/297
New Customer Analysis Question - https://forum.enterprisedna.co/t/new-customer-analysis-question-scenario-method-workshop/971
Evaluating New Customer Sales - https://forum.enterprisedna.co/t/evaluating-new-customer-sales-advanced-analytics-in-power-bi/760
For more new customer sales queries to review see here - https://forum.enterprisedna.co/search?q=new%20customer%20sales