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...
I've looked at it and as Amira pointed out, you can't use CTEs.
Please explain what is wrong with my version. It seems to work for me and you still haven't shown an example where it doesn't work.
Please refer to the 2nd page of my pbix.
See The Excel sheet - it take 4 iterations (Running Total every 15 min) your solution show 6 record per group also 10:26 - 10:12 = 14