Reply
JuanVR10
Frequent Visitor
Partially syndicated - Outbound

Accumulative sum against stock qty

Hi friends!

 

I have 2 tables, one is MB58, which shows by Cliente and Material the available stock. And another table SEGUIMIENTO PEDIDOS, which details the units consumed by Cliente, material and dispatch date.

 

293222183_10159208848593981_6974351339642418434_n.jpg293250633_10159208849293981_2545102702120591982_n.jpg

 

What I have to do is: in a PBI table visualization shows only the records of the SEGUIMIENTO PEDIDOS table that for the Client/Material the number of dispatches that add up to the total MB58 for the same Client/Material, counting from the dispatch date most recent towards the oldest, that is, if for a material X, the stock says 30, only the records of the SEGUIMIENTO PEDIDOS table will be shown whose quantity adds up to 30 considering the most recent dispatch date.

 

I've tried several ways, but it still doesn't work for me.

 

Do you have any ideas? I hope you can help me.

 

Thanks!

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Syndicated - Outbound

Hi @JuanVR10 ,

 

Based on your description, it does not seem to match the data provided in the table. My confusion is: is there a relationship established between the two tables (cliente field or something else?) ; additionally how can I count the quantities under the same inventory?

vhenrykmstf_0-1658132575726.png

Can you check the relevant data model and explain it so that I can answer it for you as soon as possible? Looking forward to your reply.


Best Regards,
Henry

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)