Returning Values from a Duplicate Code

[Syndicate_Admin]

Hello! This is working with 2 tables, in which "PEX2 Routes" contains unique values of Routes, while in the "Planning" sheet there are repeated values but the same Routes of the "PEX2 Routes" sheet. My query is, I would like to insert in the "PEX2 ROUTES" sheet the sum of the "Cost" column that contains the "Planning" sheet from its name Route.

Hoja "Ruta PEX2":

"Planning" sheet

[Anonymous · Accepted solution]

HI @Anonymous,

You can try to use the following calculated column formula to add a cost column to PEX2 table to summary planning table records:

Cost =
SUMX (
    FILTER ( 'Planning', 'Planning'[Route] = EARLIER ( 'PEX2'[Route] ) ),
    [Cost]
)

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file and show the expected result very clearly.

[Daniel29195]

@Syndicate_Admin 

link the two tables on rutas . 

so it will be one to many relationship 

then create a calculated column in the table   Ruta PEX2 as  follow  :

sumx( relatedtable( Planning , Planning[Costo] )  ) 

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏

[Syndicate_Admin]

Hello! I get that I was only expecting one parameter, not 2.