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/202...
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/
amitchandak
Super User
Super UserAnonymous , 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/