The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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() ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
90 | |
83 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |