Forum Discussion
Created Table hour 10 min
Hello to all,
I am asking for your help regarding a calculated column. I would like to be able to cut each date in 10min time slot.
Example for the 30/03/2021:
30/03/2021 00:10:00
30/03/2021 00:20:00
30/03/2021 00:30:00
30/03/2021 00:40:00
30/03/2021 00:50:00
30/03/2021 01:00:00
30/03/2021 01:10:00
30/03/2021 01:20:00
Is it possible without using Power Query ?
Thanks in advance,
Joël
Anonymous , You have crossjoin you calendar with generateseries of 10 Min
a new table like
Addcolumns(Crossjoin(Calendar, Addcolumns(generateseries(0,(24*60*60),10), "Min", time(0,[value],0))), "Datetime", [Date] +[Min])
Also check if time table can help
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
2 Replies
- amitchandak
Super User
Anonymous , You have crossjoin you calendar with generateseries of 10 Min
a new table like
Addcolumns(Crossjoin(Calendar, Addcolumns(generateseries(0,(24*60*60),10), "Min", time(0,[value],0))), "Datetime", [Date] +[Min])
Also check if time table can help
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/