Purchase & No Purchase - Last Sum Rolling 3 Months

[Chanleakna123]

Hi All , 

i'm using this measure : 

*Total All Customers = DISTINCTCOUNT(Master_Data[Customer Code])

My purpose is if i click on July - it will calculated count of Customer Purchased in last sum rolling 3 months .

For Example : Customer Code : 100006629 , purchase only 2 months , but he didn't purchase in May . But he still consider as a purchase customer . but other customers who 0 purchase within 3 months , consider as 3 months No purchase . 

so the filter will be based on selected by single selection on month. 

i will also display this by brand , category , customer , region , segmentation , etc... so we need to ensure the measure is can be applied in all type. 

[amitchandak · Accepted solution]

@Chanleakna123 , I have done something similar in this blog, see if that can help in this case

Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

[Chanleakna123]

Awesome , this is so work 🙂 
@amitchandak