Number of buys within x min

[Anonymous]

Hi everyone,

Shop A and Shop B have its own sales sorted by date.

I want to find number of goods/merchandise  that were sold within certain amount of time, lets say within 1 min, by shop

example:

Shop name     Sale Date                    # of merchandise within 1 min

Shop A           15/12/18 12:14:01         1st merchandise

Shop B           15/12/18 12:14:05         2nd merchandise

Shop A           15/12/18 19:00:23         1st merchandise

Shop A           16/12/18 10:11:01         1st merchandise

Shop A           16/12/18 10:11:05         2nd merchandise

Shop B           16/12/18 14:20:22         1st merchandise

Shop A           16/12/18 18:30:55         1st merchandise

Shop B           17/12/18 17:50:43         1st merchandise

Shop A           18/12/18 12:01:32         1st merchandise

Shop B           19/12/18 12:50:43         1st merchandise

Shop B           19/12/18 12:50:44         2nd merchandise

Shop B           19/12/18 12:50:57         3rd merchandise

......

Thanks for any help

[Anonymous]

Any ideas?

[Zubair_Muhammad · Accepted solution]

@Anonymous

Please see attached pbix file

Its a Power Query Solution...Please check the Query Editor for steps