Analysing Time based data

[Anonymous]

Hi Guys

So i have a data set which has a long list of dates and times which refer to an order creation.

I would like to analyse how mnay orders fall into a specifc time slot i.e. 12pm-3pm.

I am aware that i could create a group within the field bar but it is a large data set and would take a long time.

Any suggestions?

[Anonymous]

ve tried to Use an If statement in order to group the set of times i.e. 9am-12pm. 12pm-3pm. 3-6pm etc . However i am having trouble with this. Can anyone assist?

[jthomson · Accepted solution]

Power BI has a binning function which should do what you need it to