topic DAX for New Points of Distribution Sales Goals in DAX Commands and Tips

DAX for New Points of Distribution Sales Goals

per771 — Tue, 19 Jan 2021 22:12:56 GMT

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.

Re: DAX for New Points of Distribution Sales Goals

amitchandak — Wed, 20 Jan 2021 05:52:56 GMT

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/ba-p/1361529
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458

Re: DAX for New Points of Distribution Sales Goals

per771 — Fri, 29 Jan 2021 17:27:19 GMT

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.