DAX Measure Help

[gbarr12345]

Hey,

At some point in the future in my role I am going to need to find out 'Which customers from a certain region have not purchased a certain product in the last 3 months". 

Would anybody know of a good DAX measure that would be able to solve this so that I'd have an idea when the query arises?

Many Thanks in advance!

[Anonymous]

Hi @gbarr12345 ,

Any update on this? Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share some dummy data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[amitchandak]

@gbarr12345 , Try like

Power BI Items/Categories not sold to the customers: https://youtu.be/AbuKvAnicwo

Using a rolling three month measure

Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-3,MONTH))

Not sold = Countx(Values(Customer[ID]) ,if(isblank( [Rolling 3]), [ID], Blank() ) )