Forum Discussion

FJME's avatar
FJME
Helper I
3 years ago

Summarize value lines duplicated

Hi guys !

I'm managing a long retail provisioning list to merge in a next step with a sales table and after trying to eliminate lines due to file lenght i'm not able to merge quantity duplicate lines by shop (destination store). I tried pivot table but i need to maintain many lines ...consolidate is not an option (only values)...subtototals.... etc. I append the file (just one monthly list...) to ilustrate (initial lines highlighted).

Regards

Francisco

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    FJME , You can have a measure like

     

    sumx( summarize(Table, Table[DestinationID], Table[CategoryId], "_qty", sum(Table[Quantity]) ), [_qty])