I am trying to set up an excel \ power query or power bi document with an hourly breakdown for an entire year. However, I cannot figure out how to do this without having to hand enter the date/time, due to the day needing to be repeated 24 times before moving onto the next day and therefore does not follow a pattern that column from example will recognize and autopopulate.
I.e. I nee something that looks like this:
please help. thanks.