Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
3 years ago
Solved

Referencing 2 rows to see if equal or difference

Hello

 

I have the following table 
Cuid ending with "i" means integration, otherwise is normal project.
 
 
  Customer CUID Project Manager / Coordinator CUID_i Payroll+Integration
1 Client A 1002187BE01 John Smith 1002187BE01 Yes
2 Client A 1002187BE01i John Smith 1002187BE01 Yes
3 Client A 1002187ES01 Lebron James 1002187ES01 Yes
4 Client A 1002187ES01i Luka Doncic 1002187ES01 Yes
5 Client B 1002187CA01 John Smith 1002187BE01 Yes
6 Client B 1002187CA01i John Smith 1002187BE01

 

I created a custom formula to remove the "i" from the integration CUID.

if Text.End([CUID],1)="i" then Text.Start([CUID],Text.Length([CUID])-1) else [CUID]

 

And created another column to find duplicates. If I have a duplicate, then I have the integration + normal project. 

 

THe idea now is to get a formula.
If Payroll + Integration = yes
&&
Project manager/Coordinator  is the same in both lines then "yes", "no")
 
In the table above, Client A (+row 1 and 2) = yes
In the table above, Client A (+row 3 and 4) = no
In the table above, Client B (+row 5 and 6) = yes
 
 
Scope for Fast Track = IF('PV Cel Report'[Payroll+Integration]="Yes" &&....... 
 
but strugling to get the "Project Manager / Coordinator" part.
 
Any tip is welcome
 
thanks,
Need Help