Forum Discussion

reportuser's avatar
reportuser
Helper II
4 years ago
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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.

TheoC's avatar
TheoC
Community Champion
4 years ago

reportuser, from what I can see, AlexisOlson has provided the right solution.  He mentioned that the values for a column that does not have the Data Type set to Time will be between 0 and 1 like that in the 15Min_Data (Non-Time Data Type) column.  Yours appear to be >1. Have you set the Time column to Data Type = Time?  If not, this might be the issue. Alternatively, you may have not copied his Calculated Column formula correctly?  Either way, hope it works out as the solution provided by AlexisOlson is really sweet! (Cheers AlexisOlson!!).

 

 

reportuser's avatar
reportuser
Helper II
4 years ago

TheoC , the screenshot helped. AlexisOlson  - thank you so much for providing the solution 🙂