1. I have a column named,"STATS_DATE" which contains dates and time2. Made a new column named, "Date" which contains only date from STATS_DATE3. Made a new column named, "Time" which contains only time from STATS_DATE4. Made a new column named, "Minutes" Minutes = DATEDIFF(DATE(1899,12,30),Table[Time],MINUTE) 5. Made a new column named, "15Min_Data"15Min_Data = INT(DATEDIFF(DATE(1899,12,30),Table[Time],MINUTE) / 15)How do I convert it into intervals amitchandak ?

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.

Creating 15 Minute intervals from Date and Time Column

Forum Discussion

Related content

Dataflow Refreshes: 15 Minute Intervals?

AVERAGE USER PER 30 MINUTE INTERVAL THAT CAN BE FILTERED BY MULTIPLE COLUMNS

DAX - 15 minute Interval Question

Count rows in minute interval and find maximum value

Showing MTTR in Days-Hours-Minutes