Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying find a way to count consective row hours that are greater than two and also contain specfic flags. So in the table below the count for Parameter C and N would each have a count of 1. Any help would be greatly appreciated, as I'm not sure if I need to do this in power bi or if I can create a measure.
Kara
Parameter | Day | Hour | Flag |
C | 1/1/2019 | 1 | |
C | 1/1/2019 | 2 | |
C | 1/1/2019 | 3 | m |
C | 1/1/2019 | 4 | |
C | 1/1/2019 | 5 | m |
C | 1/1/2019 | 6 | |
C | 1/1/2019 | 7 | |
C | 1/1/2019 | 8 | m |
C | 1/1/2019 | 9 | m |
C | 1/1/2019 | 10 | |
C | 1/1/2019 | 11 | |
C | 1/1/2019 | 12 | |
C | 1/1/2019 | 13 | |
C | 1/1/2019 | 14 | |
C | 1/1/2019 | 15 | |
C | 1/1/2019 | 16 | |
C | 1/1/2019 | 17 | m |
C | 1/1/2019 | 18 | m |
C | 1/1/2019 | 19 | m |
C | 1/1/2019 | 20 | |
C | 1/1/2019 | 21 | |
C | 1/1/2019 | 22 | |
C | 1/1/2019 | 23 | |
N | 1/1/2019 | 1 | |
N | 1/1/2019 | 2 | |
N | 1/1/2019 | 3 | m |
N | 1/1/2019 | 4 | |
N | 1/1/2019 | 5 | m |
N | 1/1/2019 | 6 | |
N | 1/1/2019 | 7 | |
N | 1/1/2019 | 8 | m |
N | 1/1/2019 | 9 | m |
N | 1/1/2019 | 10 | |
N | 1/1/2019 | 11 | |
N | 1/1/2019 | 12 | |
N | 1/1/2019 | 13 | |
N | 1/1/2019 | 14 | |
N | 1/1/2019 | 15 | |
N | 1/1/2019 | 16 | |
N | 1/1/2019 | 17 | m |
N | 1/1/2019 | 18 | m |
N | 1/1/2019 | 19 | m |
N | 1/1/2019 | 20 | |
N | 1/1/2019 | 21 | |
N | 1/1/2019 | 22 | |
N | 1/1/2019 | 23 |
Hi @kararandle2710 ,
I'm a little confused about the result. Can you please share more to us? How can we get the count of 1 per parameters? Do you mean the max consecutive hours(the rows of 17,18, 19 hours for C and N)? Can you please attach a screenshot of your expected result?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response. @v-xuding-msft
The hours column is the time of day, so the flag or error would only be considered 1 time if it occurs more than three hours in a row. We have total hours online but during that time we are looking to find the count of errors to get the percentage of errors for that day or month. Does that help? See below.
Parameter | Day | Flag(Error) Count | Flag | Total Numbers online | Error % (Flag Count/Total Numbers online) |
C | 1/1/2019 | 1 | m | 12 | 8% |
N | 1/1/2019 | 1 | m | 18 | 6% |
@v-xuding-msftI was wondering if you had an opportunity to look at this again. Any help would be greatly appreciated.
Thank you!
Kara
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |