Calculate average per hour per day

Hi,

I think it is easily to reach your reqiurement.

For test, i make a small change to your sample data:

Please try to create this calculated column:

Day&Hour = 'Table'[Created date]&"-"&HOUR('Table'[Created time])

Then create this column to show the Packing slip number:

Packing slip Number = VALUE(RIGHT('Table'[Packing slip],LEN('Table'[Packing slip])-4))

Choose above two columns as a table visual, the result shows the average of Packing slip number per day per hour:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto Zhi