Last sales date, if no purchases in n days [Measure Help]

[Anonymous]

Hi,

I'm trying to create a measure that will return a customers last sales date, if no sales were made in a periode of 180 days after that date, and only return the first time this happens for a customer.

I was thinking I could use CALCULATE to find the min[SalesDate] and then filter by checking if the Revenue from that date and 180 days forward was equal to 0, but it doesn't seem to be working.

Any suggestions how to alternate the measure to get my desired result?

Last SalesDate Before Lost = 
CALCULATE( MIN(Salg[SalesDate]);
					FILTER(VALUES(Salg[CustomerKey]);
						(
							CALCULATE(Salg[Revenue];
								DATESBETWEEN(Period[Date];
									LASTDATE(Period[Date]);
									DATEADD(LASTDATE(Period[Date]);+'Customer Churn'[Churn Days];DAY)
								)
							) = 0
						)
					)
)

[anupampandey]

Hi,

I thing if you take the max transaction date of customer and take out the difference between current date and max date. If it is greater than 180 days flag them "True" else "False".

Thanks,