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
