Thank you! Linson, We can abbreviate the formula for Cohort performance like this: Cohort Performance = VAR CohortDate = MIN(DimDate[Start of Month]) Return CALCULATE( [Active Customers], REMOVEFILTERS(DimDate[Start of Month]), DimCustomer[First Transaction Month]=CohortDate )
Thanks so much for the thoughtful video series here. Definitely came in super handy when excel couldn't handle multi-column array calculations for 1M+ rows. Never thought I'd learn PowerBI at 10pm on a Monday but here we are
Hi Thank you for making these videos. They are very helpful. Dont know why for me the measure of Cohort Performance = VAR _minDate = MIN(DimDate[Start of Month]) VAR _maxDate = MAX(DimDate[Start of Month]) RETURN CALCULATE( [Active Customers], REMOVEFILTERS(DimDate[Start of Month]), RELATEDTABLE(DimCustomer), DimCustomer[First Transaction Month]=_minDate ) is not working It is giving me different results than the one you have.
Nice video again. When you overlay two tables it's indeed very pretty but when you're working with lots of data there's a scroll bar on both tables and they won't sync when you want to scroll downwards. Is there a way around it?
Good point! Unfortunately, there is no way around this. Alternatively, you can just plsit the visual and plot the new users as a trend in a different space.
Hello! Thank you for such a usefull video. I have a question: is that true to count retention trend this way? I mean, for example, when we talk about 24th month we see only "december 2009" cohort = 20% of retention rate. But on a trendline we see the % close to 0. That's because trendline calculate average between all cohort-months, even if they are not exist for 24th month. So, could you please answer, I'm not sure that this provide us the true results for business.
Thank you so much for this it is very helpful!! One question, when I make the matrix with my own data and put in the Cohort Performance measure every single field in the matrix just shows exactly the same number (the amount of customers in the first month). Do you have any idea why this might be? I havent been able to figure it out yet...
Hello Linson Sir, I hope you doing well and thanks for the video. I have a question what does active customer mean in your report does that mean a customer who have bought the product more than one time in his first transaction month. Like suppose if i am buying a product in 2009 and then i buy in 2011 will i will be counted as an active customer, Like what are the parameters in your report whom do you consider as an active customer. Thanks, Love from India to NIgeria
Thank you @hiteshjoshi3148. For this project, Yes. For subscription based business or other model of businesses the approach will be different. The approach used by this project isn't the best. For a real online store, for example, there will be predefined business rules that will guide or define some of the metrics [active, lost, resurrected, returning).
Thank you!
Linson, We can abbreviate the formula for Cohort performance like this: Cohort Performance =
VAR CohortDate = MIN(DimDate[Start of Month])
Return
CALCULATE(
[Active Customers],
REMOVEFILTERS(DimDate[Start of Month]),
DimCustomer[First Transaction Month]=CohortDate
)
Thanks so much for the thoughtful video series here. Definitely came in super handy when excel couldn't handle multi-column array calculations for 1M+ rows. Never thought I'd learn PowerBI at 10pm on a Monday but here we are
I'm glad you found this useful
Thank you for the video, inspiring and full of useful insights!
Hi
Thank you for making these videos. They are very helpful.
Dont know why for me the measure of
Cohort Performance =
VAR _minDate = MIN(DimDate[Start of Month])
VAR _maxDate = MAX(DimDate[Start of Month])
RETURN
CALCULATE(
[Active Customers],
REMOVEFILTERS(DimDate[Start of Month]),
RELATEDTABLE(DimCustomer),
DimCustomer[First Transaction Month]=_minDate
)
is not working
It is giving me different results than the one you have.
Same as mine 😢
How can i be so proficient using DAX 😢? Can I feel like knowing DAX would enable gain analyse data like a pro
Thanks for this great video.
Welcome
Nice video again. When you overlay two tables it's indeed very pretty but when you're working with lots of data there's a scroll bar on both tables and they won't sync when you want to scroll downwards. Is there a way around it?
Good point! Unfortunately, there is no way around this. Alternatively, you can just plsit the visual and plot the new users as a trend in a different space.
Hello! Thank you for such a usefull video. I have a question: is that true to count retention trend this way? I mean, for example, when we talk about 24th month we see only "december 2009" cohort = 20% of retention rate. But on a trendline we see the % close to 0. That's because trendline calculate average between all cohort-months, even if they are not exist for 24th month. So, could you please answer, I'm not sure that this provide us the true results for business.
Nice video.
Thanks!
Thank you so much for this it is very helpful!! One question, when I make the matrix with my own data and put in the Cohort Performance measure every single field in the matrix just shows exactly the same number (the amount of customers in the first month). Do you have any idea why this might be? I havent been able to figure it out yet...
hmmm. You must have gotten something wrong along the way. It will be hard to help without seeing your file.
Did You Solve It?
Hello Linson Sir, I hope you doing well and thanks for the video. I have a question what does active customer mean in your report does that mean a customer who have bought the product more than one time in his first transaction month. Like suppose if i am buying a product in 2009 and then i buy in 2011 will i will be counted as an active customer, Like what are the parameters in your report whom do you consider as an active customer.
Thanks, Love from India to NIgeria
Thank you @hiteshjoshi3148. For this project, Yes. For subscription based business or other model of businesses the approach will be different. The approach used by this project isn't the best. For a real online store, for example, there will be predefined business rules that will guide or define some of the metrics [active, lost, resurrected, returning).
can you use quickmeasures to solve this
No. Not at the moment.