Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Chicoli08
Frequent Visitor

Compare values in same column grouped by serial

I have this kind of table:

Chicoli08_0-1595397137816.png

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

 

 

1 REPLY 1
amitchandak
Super User
Super User

@Chicoli08 ,Can you share sample data and sample output in table format?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.