Forum Discussion

RMC_Candy's avatar
RMC_Candy
New Member
3 years ago
Solved

DATOS duplicados

tengo dos tablas relacionadas con id Fecha ubicación ID 20230706 Pasillo juguetes 111820230706155000 20230706 Pasillo central 111820230706133000 20230707 Pasillo central 111820230707104000 2...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi RMC_Candy ,

     

    Please try:

    Total = 
SUMX(SUMMARIZE('Table','Table'[ubicación],"Date",MAX('Table'[Fecha]),"Value",CALCULATE(SUM('Table (2)'[Cantidad]),FILTER('Table (2)',[ID]=MAX('Table'[ID])))),[Value])

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi RMC_Candy ,

 

Please try:

Total = 
SUMX(SUMMARIZE('Table','Table'[ubicación],"Date",MAX('Table'[Fecha]),"Value",CALCULATE(SUM('Table (2)'[Cantidad]),FILTER('Table (2)',[ID]=MAX('Table'[ID])))),[Value])

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.