topic Re: Created Table hour 10 min in DAX Commands and Tips

Created Table hour 10 min

Anonymous — Tue, 30 Mar 2021 13:56:06 GMT

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

Re: Created Table hour 10 min

amitchandak — Tue, 30 Mar 2021 14:31:51 GMT

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/

Re: Created Table hour 10 min

Anonymous — Tue, 30 Mar 2021 15:16:04 GMT

Great! Thanks a lot for your help amitchandak

See you soon, have a nice day!