New Customers vs Old Customers analysis in PowerBI using DAX | MiTutorials

How to Identify New Customers and Old Customers in PowerBI using DAX | MiTutorials

[dhananjayakumar]

Thanks, please explain How to derive Lost Customers, New Products and products that have no sales in the current period compared with the previous period.

[archstand]

Brilliant video !
Could you also please let me know how to get the Customer Names of New and Old customers. Thank you

[ShoaibAhmed-bcsb]

Thank you so much. Well explained. I am a beginner and i did some mistakes like closing brackets and all but eventually i made it.

[redguard]

Thank you so much for explaining and walking us through your DAX examples! It is very easy to follow.

[thanomnoimoh]

Thank you for your clip that simply to understand, Great!!!

[federicourena]

Thank you so much! I have tried to copy the formula, but I kept getting an error when the last part of this section is added. "ALL('DIM_DateTable'[Date], DIM_DateTable[Date]<CurrentDate))".

Error: A single value for column 'Department' in table 'DIA SALES DATA' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

[ravindrasinghsuri]

Hi MITutorials,
Thank you for this,
is it possible to share the which customer is a new customer?

[rajeshwarraodugyala]

easy and simple explanation. informative

[WaqasGulll]

Thank you sir for sharing this precious learning.
I have a request, how can we get lost customers based on slicers(Year and MonthName from calendar)
If 2023 selected so the table will show customer name, New customer sales which start sales in 2023.
Repeat customers sales which were available in previous months and years also.
Lost customers sales which were available in 2023 but when i select 2023 then table can show these customers previous sales in negative to know how much sales we lost in current period of which customers?

[lataloungani]

Thank you for sharing.
What's the definition of new customers in this case ? Customers who have not visited during the year (12M) or works backwards from the date selected to 365 days ? Ex: if we are in the first month of the year, let's say Jan. Does it consider all customers who have not visited from Feb last year to Jan this year or only Jan ?
Also, it would be helpful to understand lapsed customers i.e. customers who visited in past years and have returned after a gap of 1 year or 2 years.

[jayantsenguptarock]

How can i calcualte Lost Customers from these measures.

[dataanalyst]

hai, thanks you for the tutor, you save me a lot, how about lost customer, can you give tutorial.

[jnorth]

Liked and Subscribed! Would love to know how I can leverage this to get "Active Accounts" in the last 90 days

[jayantsenguptarock]

Thanks to you for making it easily understandable 😄
I have a quick doubt. If we divide Old Customers by Total Customers, we'll get the Retention Rate right ?

[irfandaud]

Nice.

Created Data from July 21 to Dec 21 and Date table as well.

When i use the Measure for No. of New Customer, (First Month, July 21) customers are shown as new customers. However, in your work, For January 2020. No. of new customers are Zero. How?

[jayantsenguptarock]

Hi.
Its only working when I'm selecting a particular year.
I've marked all years and now "New Customers" is showing up as same as "Total Customers" & "Old customers" is coming up as 0. Anyone have any idea why is it happening ?

[r_a_j_d_e_e_p_c]

Please send the link "How to create a calendar table from a customer

[gagansingh]

How we calculate the old, new, retained customer for last 30, 90, 180 days can you please make a video and days we can dynamically change it ..Sir

[neerajraut]

I am applying the same formula for my project, but the total no. Of customers and new customers both values are same and that's why the value of old customer is 0... I have the data of only one year, , , how am i supposed to solve this?