How to Flag customer not buying more then 6 month ?

[Paulyeo11]

Hi All

https://www.dropbox.com/s/c6qr04pdyzielf0/PBT_V2021_112%20flag%20more%20then%206%20month%20not%20buy...

My PBI file

Paul

[amitchandak]

@Paulyeo11 , Have rolling 6 measure , exmple

Rolling 6 = CALCULATE([Sales],DATESINPERIOD('Date'[Date],ENDOFMONTH('Date'[Date]),-6,MONTH))  

No transaction in last 6 month = Sumx(VALUES(Customer[Customer Id]),if(ISBLANK([Rolling 6]) , 1,BLANK()))

Change mesure/column  as per need

refer my blog on similar lines

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

[Paulyeo11]

Hi Amit

Thank you for your sharing , that is what i need , i get error :-

https://www.dropbox.com/s/1obxq18jgd6945s/PBT_V2021_112%20flag%20more%20then%206%20month%20not%20buy...

Above is my PBI :-

I create 7 month rolling at Date table .

Paul

[amitchandak]

@Paulyeo11 , extra ] that was causing

try , use in a measure not in column

Sumx(VALUES(SALES[COMPANY]),if(ISBLANK([Rolling 6]) , 1,BLANK())) 

[Paulyeo11]

Hi Amit 

now no more error , may i know how to use the field not buy for last 6 month ? i try to place at filter panel , it does not work. as i can drag the field in.

Paul