Forum Discussion
Solved
Creating 15 Minute intervals from Date and Time Column
1. I have a column named,"STATS_DATE" which contains dates and time 2. Made a new column named, "Date" which contains only date from STATS_DATE 3. Made a new column named, "Time" which cont...
Try formatting this as Time data type:
15Min_Data = ROUNDDOWN ( 'Table'[Time] * 24 * 60 / 15, 0 ) / ( 24 * 60 / 15 )You can just use 96 instead of 24 * 60 / 15 since there are 96 fifteen-minute intervals in one day.
What is the end result that you want? What should the column look like?
The end result could be the start of the 15 minute interval like so
12:00 AM
12:15 AM
12:30 AMTry formatting this as Time data type:
15Min_Data = ROUNDDOWN ( 'Table'[Time] * 24 * 60 / 15, 0 ) / ( 24 * 60 / 15 )You can just use 96 instead of 24 * 60 / 15 since there are 96 fifteen-minute intervals in one day.
How do I display the intervals?
