Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Returning Values from a Duplicate Code

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's avatar
    Anonymous
    2 years ago

    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

4 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    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! 🙏

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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