Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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
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.
@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() ) )
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |