Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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)
Proud to be a PBI Community Champion
@まもる 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)
Proud to be a PBI Community Champion
Wonderful great
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.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |