Time Bin Intervals

[trevordunham]

I have searched for a while but only have found solutions using start and end times and recreating those solutions has not worked.

What I am looking for is to create a table that on one axis has day and the other axis has time intervals (30 mins) so I can display the number of tickets in each 30 minute interval for every day in a given month. Creating bins using the built in feature carries the date along with it so I end up with a massive table that shows the date with every time interval. I am just looking to have 30 minute bin vs day. 

To be a little more clear, the field I am trying to convert is a date + time field. I am using that date + time field twice on the same matrix. One axis being the day of that date time field, the other axis being a 30 minute interval bin of that date time field. While the values are just a count of tickets.

Any solutions?

[trevordunham · Accepted solution]

I was able to get this to work simply by splitting by date time field into date and time seperately then using the group/bin function on just the time field.

[Greg_Deckler]

@trevordunham Seems like a variation on Open Tickets. If you can post sample data, could be more specific.

Take a look at these two Quick Measures as I think you want something like them.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365

[trevordunham]

This is one of the solutions I came across that I mentioned involves open and close times. I was unable to use this as a solution.