Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
Anonymous
Not applicable

Analysing Time based data

‎02-14-2018 02:49 AM

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?

Labels:
Message 1 of 3
680 Views
0
1 ACCEPTED SOLUTION
jthomson
Solution Sage
Solution Sage

‎02-14-2018 02:51 AM

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

View solution in original post

Message 2 of 3
747 Views
0
2 REPLIES 2
Anonymous
Not applicable

‎02-14-2018 06:04 AM

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?

Message 3 of 3
657 Views
0
jthomson
Solution Sage
Solution Sage

‎02-14-2018 02:51 AM

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

Message 2 of 3
748 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All