Automatic generation of date and time data every 5 minutes.

[まもる]

I will post it for the first time.
Please let me know if you know.

I want to automatically generate date and time data every 5 minutes instead of date data like CALENDAR.

CALENDAR("2018/10/1",TODAY())
2018/10/01 0:00:00
2018/10/02 0:00:00
2018/10/03 0:00:00
2018/10/04 0:00:00
2018/10/05 0:00:00
etc.

The data I want (every 5 minutes)
2018/10/01 0:00:00
2018/10/01 0:05:00
2018/10/01 0:10:00
2018/10/01 0:15:00
2018/10/01 0:20:00
2018/10/01 0:25:00
2018/10/01 0:30:00
2018/10/01 0:35:00
2018/10/01 0:40:00
etc.

I can not speak English.  I'm sorry if English was wrong.
Thank you.

[PattemManohar · Accepted solution]

@まもる Please try this as a "New Table"

Table = 
var _min = SELECTCOLUMNS(GENERATESERIES(0,60,5),"Minutes",[Value])
var _hour = SELECTCOLUMNS(GENERATESERIES(0,23),"Hour",[Value])
var _date = CALENDAR("2018-11-01","2018-11-02")
RETURN FILTER(CROSSJOIN(CROSSJOIN(_hour,_min),_date),[Minutes]<>0)

Then add a "New Column" (Which will be final expected output) as below

Final = [Date]+TIME('Table'[Hour],'Table'[Minutes],0)

[Siv_Abu]

Wonderful great

[まもる]

@PattemManohar

Hello.  Thank you for your information.
It's perfect!

Thank you very much.

I'm so sorry.  I have an additional question.

Do you know how to generate this with Power Query?

Thank you.