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
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
Go to Solution.
Please see attached pbix file
Its a Power Query Solution...Please check the Query Editor for steps
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!