Forum Discussion
Anonymous
8 years agoNot applicable
Analysing Time based data
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?
Power BI has a binning function which should do what you need it to
2 Replies
- jthomsonSolution Sage
Power BI has a binning function which should do what you need it to
- AnonymousNot applicable
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?