Cohort Analysis with repeating orders

[Anonymous]

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

[v-chuncz-msft]

@Anonymous ,

You may try DATEDIFF to apply virtual relationship in DAX measure.

[Anonymous]

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?