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.
Hello, i would like to count the number of Events that are out of especificacion (IN = 0, OUT = 1), based on time and criteria,
For example My variable has criteria for every 3 points out, should be an anomaly, but if is for example 10 consecuite points out, it should also count as 1 anomaly,
VARIABLE
FECHA | HORA I | HORA F | IN = 1, OUT = 0 | CRITERIA | |
1/02/2021 | 00:00 | 08:00 | 2.09 | 0 | 3 |
1/02/2021 | 08:00 | 16:00 | 3.33 | 0 | 3 |
1/02/2021 | 16:00 | 00:00 | 2.13 | 0 | 3 |
2/02/2021 | 00:00 | 08:00 | 4.34 | 1 | 3 |
2/02/2021 | 08:00 | 16:00 | 3.29 | 0 | 3 |
2/02/2021 | 16:00 | 00:00 | 8.81 | 1 | 3 |
3/02/2021 | 00:00 | 08:00 | 9.37 | 1 | 3 |
3/02/2021 | 08:00 | 16:00 | 5.37 | 1 | 3 |
Can you add expected output to the table?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Thanks, please use the following;
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |