Filter to sales from same address within 14 days

[Anonymous]

Hi everyone,

I have a database with a field for 'customer address' and a field for 'sales date'. I've been asked to put something together that filters any instances where we record 2 or more sales from the same address within 14 days - can anyone advise the best way to put this together please? Is this something that could be done in an initial power query or requires additional columns/measures?

Thank you! 

[Anonymous]

Hi thanks for this wonderful solution, it is great. 

How would be best to present the data within a table? Ideally I would like a table with a slicer so people can select date and then within the table it shows (for example) all details for BOTH sales within a 14 day period rather than just the last one?

Thank you! 

[amitchandak · Accepted solution]

@Anonymous , you can rolling 14 days measure

Rolling 14 = CALCULATE(countrows(Table),DATESINPERIOD('Date'[Date],max('Date'[Date]),-14,DAY))

And create a measure check how many address more than one rows in last 14 days

MT 1= countx(filter(summarize(Table, Table[customer address], "_1", [Rolling 14] ), [_1]>1),[customer address])