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,
