Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have below excel wherei need to calculated total count and result. if 2 or more record breach then it will be failed. and if time crosses 99 (only in True case) then it will be failed.
Priority | Ticket no | SLA breach | Duration in sec |
P1 | 1234 | TRUE | 100 |
P1 | 6854 | FALSE | 2 |
P3 | 6754 | FALSE | 3 |
P2 | 2453 | TRUE | 56 |
P2 | 8669 | TRUE | 78 |
P3 | 7585 | TRUE | 64 |
So, expected below output
Priority | Total Ticket | Result |
P1 | 3 | Fail |
P2 | 2 | Fail |
P3 | 2 | Pass |
Any help would be appreciated
Solved! Go to Solution.
pls try this
Proud to be a Super User!
what do you mean by 2 or more record breach?
Proud to be a Super User!
It means 2 or more ticket breached ( SLA breach will be True) for a single type. for above example its P2, where breach count is 2 as both are True
pls try this
Proud to be a Super User!
I think its my typo mistake. I will check this solution. Thanks for your help
you are welcome
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |