Forum Discussion
Calculate Overlap based on Interval and Frequency
This is what i would do considering that you only have 24 jobs,
I would convert the start of interval to numeric minutes.
00:00:00 would be 0
09:00:00 would be 540
24:00:00 would be 1440
Etc...
Next, create a list for each job by using List.Numbers with the new start value. Use number of runs per day as the count and the interval as the increment.
https://docs.microsoft.com/en-us/powerquery-m/list-numbers
This should give you a row for each time a job is run. So a single job that is run 1440 times should now have 1440 rows.
With this you should be able to display exactly how many jobs are running each minute.
I hope that you understand! :)
Good luck,
Johannes
There are 24 jobs with intervals between 1 minute and 2 hours with those specified in the attached screen shot of the table. I have already calculated the number of times a job is run per day in the column "Number of Runs per Day" based on the "Interval(Minutes)" and the "Number of Hours" from "start of interval" to "end of interval".
I'm trying to determine how many times multiple jobs are running per minute per day and call that the "Count of Overlap".
Do I need to make new columns and/or measures in order to calculate this?
Community ChampionThis is what i would do considering that you only have 24 jobs,
I would convert the start of interval to numeric minutes.
00:00:00 would be 0
09:00:00 would be 540
24:00:00 would be 1440
Etc...
Next, create a list for each job by using List.Numbers with the new start value. Use number of runs per day as the count and the interval as the increment.
https://docs.microsoft.com/en-us/powerquery-m/list-numbers
This should give you a row for each time a job is run. So a single job that is run 1440 times should now have 1440 rows.
With this you should be able to display exactly how many jobs are running each minute.
I hope that you understand! :)
Good luck,
Johannes