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
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!