Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cohort Analysis with repeating orders

Hi all,

 

I've got quite a specific problem I'm hoping you can help me with.

 

I'm working on migrating our customer retention analysis from Excel to PowerBI but one area is proving really tricky. We have a product that is 3 months' worth of stock at a time, and this should count towards retention at month x, x+1 and x+2. I can't work out a way to do this. 

 

Anyone able to help me?

 

Thanks

Oli

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Hey there, thanks so much for your reply. The buckets I'm using are of varying size, so I'm not sure datediff will help. Do you need more info in order to assist?