Power BI Creating time factors

Question

I usually have data updates on an hourly basis. I would like to format and view the mean of these values across different time factors. Such as daily, weekly, monthly, nightly (9 pm to 6 am) and so on.

I've looked at splices and the DAX formatting of new columns and been playing around with that - but so far been unsuccessful.

Data example

Date                Value
28-06-2016 01:00    1
28-06-2016 02:00    1
28-06-2016 03:00    6
28-06-2016 04:00    9
28-06-2016 05:00    15
28-06-2016 06:00    17
28-06-2016 07:00    18
28-06-2016 08:00    21
28-06-2016 09:00    25
28-06-2016 10:00    30
28-06-2016 11:00    38
28-06-2016 12:00    41
28-06-2016 13:00    43
28-06-2016 14:00    45
28-06-2016 15:00    50
28-06-2016 16:00    57
28-06-2016 17:00    58
28-06-2016 18:00    60
28-06-2016 19:00    70
28-06-2016 20:00    77
28-06-2016 21:00    85
28-06-2016 22:00    85
28-06-2016 23:00    91
29-06-2016 00:00    91
29-06-2016 01:00    97
29-06-2016 02:00    99
29-06-2016 03:00    99
29-06-2016 04:00    100
29-06-2016 05:00    104
29-06-2016 06:00    113
29-06-2016 07:00    122
29-06-2016 08:00    125
29-06-2016 09:00    126
29-06-2016 10:00    134
29-06-2016 11:00    143
29-06-2016 12:00    150
29-06-2016 13:00    158
29-06-2016 14:00    162
29-06-2016 15:00    171
29-06-2016 16:00    174
29-06-2016 17:00    179
29-06-2016 18:00    181
29-06-2016 19:00    185
29-06-2016 20:00    195
29-06-2016 21:00    197
29-06-2016 22:00    203
29-06-2016 23:00    205