Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

  • jthomson's avatar
    jthomson
    Solution Sage

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

  • Anonymous's avatar
    Anonymous
    Not 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?