Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Grouping times during a day

Hi Guys.

 

I am attemtping to group a set of times throughout a day into different categrories.

 

i.e. 8am-12pm is group 1. 1pm to 5pm is group 2 and so on.

 

The grouping/bin fucntion  is still not working within BI desktop.

 

can anyone provide some help for a formula?

 

 

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

Hi @Anonymous

 

You can create a small paramter Table defining your Range of Times. For example

 

GroupStart TimeEnd Time
Group 1812
Group 21224
Group 308

 

Then you can add a calculated column in your main table... determining the Group in which each time falls.

Using a column like

 

=
CALCULATE (
    FIRSTNONBLANK ( Parameters[Group], 1 ),
    FILTER (
        Parameters,
        HOUR ( TableName[Time] ) >= Parameters[Start Time]
            && HOUR ( TableName[Time] ) < Parameters[End Time]
    )
)

 


Regards
Zubair

Please try my custom visuals

View solution in original post

1 REPLY 1
Zubair_Muhammad
Community Champion
Community Champion

Hi @Anonymous

 

You can create a small paramter Table defining your Range of Times. For example

 

GroupStart TimeEnd Time
Group 1812
Group 21224
Group 308

 

Then you can add a calculated column in your main table... determining the Group in which each time falls.

Using a column like

 

=
CALCULATE (
    FIRSTNONBLANK ( Parameters[Group], 1 ),
    FILTER (
        Parameters,
        HOUR ( TableName[Time] ) >= Parameters[Start Time]
            && HOUR ( TableName[Time] ) < Parameters[End Time]
    )
)

 


Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.