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. ...
  • 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

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