Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
I get at list of jobs everyday, and I want to be able to see if a jobe have failed or is missed more than one day in a row. I have manualy create a short example, but I would like to know how to do this in Power BI, as I have over 1000 jobs.
I would to be able to show the counts on a date line, with the number of consecutive days of failurs or missed, but when there have been just one day without failure or missed the count should start over.
Data:
Date | Name | Status | Count | Note |
01-01-2022 | Name1 | Missed | 01-01-20222 = 1. jan 2022 | |
01-01-2022 | Name2 | Missed | ||
01-01-2022 | Name3 | Missed | ||
01-01-2022 | Name4 | Failed | ||
01-01-2022 | Name5 | Failed | ||
02-01-2022 | Name6 | Missed | ||
02-01-2022 | Name1 | Missed | ||
02-01-2022 | Name3 | Missed | ||
02-01-2022 | Name7 | Missed | ||
03-01-2022 | Name1 | Missed | ||
03-01-2022 | Name2 | Missed | ||
03-01-2022 | Name3 | Missed | Missed 3 days consecutive | |
03-01-2022 | Name7 | Missed | ||
04-01-2022 | Name6 | Missed | ||
04-01-2022 | Name7 | Missed | ||
04-01-2022 | Name5 | Missed | ||
04-01-2022 | Name1 | Missed | Missed 4 days consecutive | |
05-01-2022 | Name1 | Failed | ||
05-01-2022 | Name2 | Missed | ||
05-01-2022 | Name3 | Missed | ||
05-01-2022 | Name7 | Missed | ||
06-01-2022 | Name6 | Missed | ||
06-01-2022 | Name7 | Missed | Missed 4 day consecutive | |
06-01-2022 | Name5 | Missed | ||
06-01-2022 | Name1 | Failed | Failed 2 days consecutive | |
06-01-2022 | Name2 | Missed | Missed 2 days consecutive |
Overview:
Name1 | 4/1 Missed 4 days consecutive |
Name1 | 6/1 Failed 2 days consecutive |
Name2 | 0 days consecutive |
Name2 | 6/1 Missed 2 days consecutive |
Name3 | 3/1 Missed 3 days consecutive |
Name4 | 0 days consecutive |
Name5 | 0 days consecutive |
Name6 | 0 days consecutive |
Name7 | 6/1 Missed 5 days consecutive |
Solved! Go to Solution.
@Lerager Sounds like a repeating counter with conditions, otherwise known as Cthulhu:
Cthulhu - Microsoft Power BI Community
@Lerager Sounds like a repeating counter with conditions, otherwise known as Cthulhu:
Cthulhu - Microsoft Power BI Community
Hi again Greg
First thanks for the solution, it worked.
My new challenge is to only collect the highest number of a sequence in Cthulhu and also the larst date value together with the Cthulhu value.
Is that possible?
So I'm not intereted in all the counts 1, 2, 3, 4 and 5, only 5 and the information related to this entry.
Regards Bent
Never hear of Cthulhu before, but as I read this I can't use it, as I don't have an "Index", I only have a date, that can have multiple entries of jobs.
It is not as easy as a counter where all jobs comes listed one by one.
Thanks
@Lerager You can use either Index or Date, anything that defines "before". Here is another example where I believe dates were used. (3) Bride of Cthulhu! - Microsoft Power BI Community
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |