Customer Retention in Power BI DAX Measures

preview_player
Показать описание
Customer retention is one of the most common scenarios of data analysis, which is very useful for business. As a business, you would like to know how many new customers you have in each month, how many returning, and how many lost customers. Knowing these, would help you to focus on the growth plan, and bring more new customers, keep more returning customers, and reduce the number of lost customers. I have written previously about a simple way to find out which customers are new, or lost. However, in this video, I am going to share more details about some other analysis that can be useful, especially when you want to analyze the customer retention for each period (when the date is an axis of the chart).
Download the file and read more explanation from my blog article link here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses at RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********
Рекомендации по теме
Комментарии
Автор

Great explain sir, because of you, i clear my interview . thanks. make more video like this

raviranjansingh
Автор

Thanks for the great explanation! If we had also product table in the model, would it work the same way if we use the product as a slicer?

keremo
Автор

where is the link to download the file?

lukaspedersen
Автор

Reza you are a Rockstar! Excellent tutorial, thanks!

agusparma
Автор

Tried following on the blog but there are no clear instructions as to what the calculation [Sales until now] relates to other than a comment saying it is an "add column". Could you expand on that?

unlistedgabriel
Автор

where i will get the dataset used in this video ??

ketanrode
Автор

Thanks, it was wondeful, can I calculate for new customer in certain year?

ColorfulData
Автор

Can you please share the file with us?

imamverdigahramanov
Автор

Salam Agha REZA, How can I just divide my customers into NEW and OLD categories. Just to say if the First purchase date is >2020 then OLD otherwise New??? I would appreciate it so much if you can help me? Merci!!!

Hamid-tbkc
Автор

what if we want to calculate % of retention rate please ?

montassarbenkraiem
Автор

How can I do Waterfall graphic with new, lost, returning customers?

SayuriValente