DAX for New Points of Distribution Sales Goals

[per771]

I am a functional beginner with DAX and Power BI and am working on reports for our sales managers. One of the goals that they assign their sales team members involves new 90-day unsold PODs (Points of Distribution). So I need a way to get a count of new sales of certain products to accounts that have not bought the product for at least the past 90 days. I have all the necessary data in my dataset, but I'm not sure how to write the DAX to get the result I need for the visuals.

I would appreciate any help towards the answer.

[per771]

Will this have to be a calculated column? It seems that each sale would need to be evaluated as a product that hasn't been sold in that account for the past 90 days, which I think would require a column?

Is the 90 day rolling measure above from the current day or the three previous calendar months? I need a measure that will evaluate 90 days back from the current day if possible.

[amitchandak]

@per771 , Try measures like these

Rolling 90 sales = CALCULATE([Sales],DATESINPERIOD('Date'[Date],ENDOFMONTH('Date'[Date]),-90,DAY))


Product No Sales in This Period = Sumx(VALUES(Customer[Customer Id]),if(ISBLANK([Rolling 90 sales]) , 1,BLANK()))

Refer my artricles on related topics

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