Forum Discussion
Time interval
Hi there, See image below. In the left I have SQL Server table called example with two ID's And DTTM columns. I need it to capture 15 running min interval with reseting the loop (every 15 min set...
It's still not accurate it sould be 5 records per group 8:00 , 8:15, 10:12, 10:32 , 10:47
Hi Oded-Dror
OK. Lets look at the 2nd page. When you click on a line in the upper table, it will filter the bottom table.
For 8:00, the earliest is at 8:00. There is also one at 8:05 and another at 8:07.
For 8:15, the earliest is at 8:15. There is also one at 8:25.
etc.
DimTime - 15 minute buckets.pbix