Forum Discussion
erwin67
2 years agoRegular Visitor
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...
erwin67
2 years agoRegular Visitor
Hi,
Minute will be enough. I will work with this two functions and see what I get.
I'm not sure if I neet to look for a day. For every item in table 1 I need to look in table 2 how many failure events in table two have there start time in the time frame of the item. My biggest issue might be the size of table two that can have thousands of rows.
I think that a solution might be to seperate both tables in days first and than doe the counting seperately per day.
The dataset includes whole 2023 and it is massive.