I think this was one of the most useful and to the point videos on power bi. You always rock. I have learned power bi by watching your videos and reading your posts.

Ideally this is a wrong assumption because we are calculating last date of each customer, suppose a customer bought from us in the year 2005 this formula would calculate last date in this customers context and will give the results, however, the starting date should be current date always which would be today or the maximum date in current data set.

Hope to learn more and more PowerBI from your clear presentations. Thank you

Well done, thanks will definitely try with my customers database, but for now I'm still learning the basics

سلام روز بخیر خیلی ممنون بابت ویدئوی خوبتون ، من یه loyalty program دارم که برای بیزینس های مختلف پیاده سازی میکنیم در قالب یک باشگاه مشتریان ، امکانش هست فرمول مربوط به دسته بندی های زیر رو طوری به من بدید که برای هر نوع کسب و کاری قابل استفاده باشه : 1 - قهرمانان 2 - وفداران 3 - مشتریان نیاز به توجه at risk 4 - مشتریان از دست رفته lost 5 - مشتریان پولدار 6 - مشتریان کم پول چون میانگین مراجعه مشتری ها برای هر کسب و کار بازه های متفاوتی هست ، پس ما نیاز داریم که اول میانگین مراجعات مشتری ها رو در بیاریم و این میانگین باید به ازای هر گروه محصول باشه چون دوره برگشت مشتری در هر گروه محصول هم ممکنه متفاوت باشه. اما نکته اینجاست : فرض کنید میانگین مراجعه هر مشتری در یک گروه کالای بخصوص 30 روزه ، حالا اگه یک مشتری چقدر بیشتر از 30 روز مراجعه نکنه "از دست رفته" محسوب میشه ؟ آیا اگه یک مشتری 31 روز مراجعه نکنه بهش میگن از دست رفته ؟ میدونم شاید درخواستم نوعی سوء استفاده به نظر بیاد اما اگر بتونید فرمول ریاضی این موارد رو بگید میتونیم با کد نویسی پیاده سازیش کنیم

This tutorial has solved many questions. Thanks a lot for doing such good work.

Really nice and clearly explained! You might consider using different period for lost and new customers though. For example we consider a customer 'lost' if he didn't order in 12 months, but consider a customer 'new' if he has ordered in the last 3 months and not before. I'm also curious about handling totals :-)

If you're struggling to have the subtotal of lose clients or new clients - You need to create a new table just with the clients (you can use 'group by' on Power Query using your sales table) - Then you need to relationship these 2 tables - Now you will create a measure TOTAL_LOST_CLIENTS = SUMX('YOUR_TABLE_GROUP_BY';YOUR_SALES_TABLE[LOST_CLIENTS_MEASURE])

How do I create an overview table that sums number of lost customers? and then show a detailed list next to it with who it is.

Thank Sir, This has been a very clear presentation.

Please tell me how to count the lost customers in this case. I have done the same and now want to show the total number of lost customers in card visual. I need your support, because its a must requirement for me.

Thank you Sir, this is a great video, you clear in only 12 minutes questions I had since many days ago

This is an amazing tutorial. Thanks a lot for sharing.

Amazing video and super helpful! One of the best I found. Is there a way to use Lost Customers as a slicer?

thanh you soooo much. This is exactly what I am looking for. Merry Christmas!!!

Dear Reza, That was really insightful. Thank you for sharing.

Thanks Rad, this is very helpful!

Excellent and useful! Thank you.

Thank you very much for this great inspiration. Great quality, great explanation. Thumb up and I will became a loyal subscriber.

This was a great video! one drawback, your grand total isn't working, you need to use a sumx to fix that.

Simple and really practical!

Awesome !!! Thank you for this.

Awesome sir could you please make it on date as well

Amazing video! Many thanks!

Excellent!

VERY NICE VIDEO

how do you get the dynamic number for lost numbers and new users

Hey! Thank u for your video! It’s perfect, only I have a little problem....I want to put in a card the number of new customers “1” that I have in my table.....how I can do it ?? It doesn’t work 😭

Simple & effective ...thank you .....is there any way to count those lost customers or sum

Thank you for this.

Excellent! Thanks ! Btw, may i know how to count those lost customers? i've tried this dax Number of lost cust = CALCULATE( COUNTROWS(Sales), FILTER( VALUES(Sales[Customer Name]),[Lost Customer]=1) ) but the value is not accurate.

great, very useful, could have just a counter for lost and won customers

Like the basic concept of these logic.

I love your video but when I try and do it, it works BUT I also want to know the Total Lost Customers and in your example and mine that I made the Total Lost Customers is 0 which does not add up to give me the total lost customers ? How do I fix that ?

How can we get the total lost customer? The current if statements output is not showing a grand total

Thank you very much!

Interesting, but it would be more useful to have New, Lost or Continuing all in one Colum to use as a filter.

Hi Reza, I have one questions about the data model, instead of date if we have a customer id, week number, purchase by week

Please tell me how I can count the deleted items from last month for each category? I tried to use your example but it seems not working or maybe I do something wrong.

Sir,How to get total of lost customers? it is 0 why?

How can you calculate the total lost customers then with that measure?

hello. I been triying to do the last sales formula. it happens that my calendar table has greater dates than de last invoice date so I tried to use last day of invoice table as last date but i cant figure out why it isn't working. The behavior is strange since last date brings older sales than selected period. what can it be the problem? thans best regards.

Hi Raza, How can i rewrite this DAX in better performance , Please help on this. It till execute around 60 seconds, sales table contains 9 crores on records Active Member Base Last 2 Year:= CALCULATE( distinctcount(Sales[Customer]), Sales[New Customer Flag] in {1,0}, DATESBETWEEN( 'Date'[Date], DATEADD(FIRSTDATE('Date'[Date]),-23,MONTH), LASTDATE('Date'[Date]) ), ALL('Date') )

How to calculate retained customers

If Im using a date slider as my selection, how do I encorporate the date from this. Does the low and high date on the slider get seen as variables? If I want to look back 12 months from the higher date what do I use.

Is there a way to make that new customer value a dimension so you can filter on it?

im tring to display the sum of of lost revenue using difference between total and period sum filtering for lost customer, but i cant make it work dax im trying lostrev= calculate([difference total-period]; filter(invoice; lostcustomer=1)) anyone can help?

Where can i find the sample data used?

Awesome

countx not working

how can we know the lost customers among all the data no i a specific period?

Hello Sir can you please share link to data or order date format.