Forum Discussion

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago

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 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!

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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() ) )

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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