The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have this kind of table:
Where I have some tools, every serial must have an SR (send to a job)and an AT (Maintenance the tool) interspersed. If a tool goes to a job, just to have maintenance before.
Every tool (serial), must have an AT before an SR and after.
I would like to create a calculated column with "CRIME" if this rule is broken.
Thanks in advance.
Best regards
User | Count |
---|---|
24 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |