Random hourly values to continuous time series

[BI2018No]

Hello!

Is it possible to transfrom "random hourly values" to continuous time series (hourly) in Power BI? Perhaps also calculate daily average? Se table belov. 

from this: 

Time	ID	Value
01.01.2018 16:00	1	12,5
01.01.2018 18:00	1	13,2
03.01.2018 00:00	1	15,4
08.01.2018 15:00	1	16,1
03.01.2018 16:00	2	14,2
03.01.2018 18:00	2	14,9
05.01.2018 00:00	2	17,1
10.01.2018 15:00	2	17,8

into this

Time	ID	Value
01.01.2018 16:00	1	12,5
01.01.2018 17:00	1	12,5
01.01.2018 18:00	1	13,2
01.01.2018 19:00	1	13,2
01.01.2018 20:00	1	13,2
01.01.2018 21:00	1	13,2
01.01.2018 22:00	1	13,2
.
.
.
03.01.2018 16:00	2	14,2
03.01.2018 17:00	2	14,2
03.01.2018 18:00	2	14,9
.
.
.

[Zubair_Muhammad]

Hi @BI2018No

Do you want the time series to stop at

01.01.2018 23:00

?

[BI2018No]

No. It should continue all the way to the last timestamp in the "source" table. 10.01.2018 15:00