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...
Hi Oded-Dror
I added a time dimension with 1 row per minute. It also has a 15-minute bucket. (I added a DimDate table.)
After adding a couple of relationships and measures, my model is below.
DimTime - 15 minute buckets.pbix
Let me know if you have any questions.
Amira,
Thank you for solving this issue, it works!
Point to remember DAX dateadd func dosen't have Minute interval like SQL dose.
Thanks again
Oded Dror
Amira,
This is not accurate if you see in your result 10:26 - 10:12 is 14 min and not 15
And the last record as wellThanks,
Oded Dror
Hi Oded-Dror
10:26 DOES belong in the Group 10:15 since that group would span from 10:15 to 10:30.
Please double-check your findings.