Created Table hour 10 min

[Anonymous]

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

[amitchandak · Accepted solution]

@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/

[Anonymous]

Great! Thanks a lot for your help @amitchandak 

See you soon, have a nice day!