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
bnpendley
New Member

Power Query Question

I am new to Power BI., and I am lost at the moment.  I need to make this data show in a power bi report as an hour/building

I need to see the check-ins by the hour for each building.   I have grouped by building but still cannot figure out the best way to change the data to show by the hour for building?

Check In dateCheck In TimeBuilding
7/15/2022 Ridgecrest North
7/15/2022 Presidential II
7/15/202210:58:00 AMPresidential I
7/15/2022 Ridgecrest West
7/15/2022 Blount
7/15/2022 Paty
7/15/202210:57:00 AMPresidential I
7/15/2022 Riverside West
7/18/20221:33:00 PMEast Edge Apartments
7/20/202211:00:00 AMBryant
7/20/20225:01:00 PMMary Burke West
7/20/202212:00:00 PMMartha Parham East
7/20/202210:54:00 AMLakeside West
7/22/20229:38:00 AMTutwiler
7/22/20229:37:00 AMTutwiler
7/22/20229:35:00 AMTutwiler
7/22/202210:04:00 AMTutwiler
7/22/202210:12:00 AMTutwiler
7/22/20229:55:00 AMTutwiler
7/22/202210:20:00 AMTutwiler
7/22/20229:50:00 AMTutwiler
7/22/202210:24:00 AMTutwiler
7/22/20229:34:00 AMTutwiler
7/22/202210:22:00 AMTutwiler
7/22/20229:49:00 AMTutwiler
7/22/20229:28:00 AMBlount
7/22/202210:16:00 AMTutwiler
7/22/20229:26:00 AMBlount
7/22/202210:00:00 AMTutwiler
7/22/20229:43:00 AMTutwiler
7/22/20229:41:00 AMTutwiler
7/23/20221:00:00 AMRidgecrest North
7/23/2022 Presidential II
7/23/20221:30:00 PMJohn England Jr.
7/23/20228:00:00 PMMary Burke East
7/23/2022 Bryce Lawn
7/24/20226:00:00 PMJohn England Jr.
7/24/2022 Presidential I
7/25/2022 Bryce Lawn

 

 

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@bnpendley You could create a new custom column using Time.Hour and then group by date and hour?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@bnpendley You could create a new custom column using Time.Hour and then group by date and hour?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

Top Solution Authors
Top Kudoed Authors