Forum Discussion
Count events between start and end time
Hi all, I'm working with PowerBi for a while and run into an issue now where I reach the end of my skills and would like to ask for help. I searched the forum and found some hints, but nothing that...
lbendlin
Super User
Super UserYou do this by using GENERATESERIES and INTERSECT.
How granular does it need to be? Second level or minute level? For minute level you are looking at temporary tables with 1440 rows per day, for second level at 86400 rows per day. That will become unsustainable fast.