Forum Discussion
DAX Measure Help
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 kn...
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() ) )