Waterfall Chart with Two Dates

[Anonymous]

Hello!

First time posting and I have some sample data.   sample 

I have three tables:

Key Table

Purchasing Table

Delivery Table

There are multiple orders Purchase Orders open, each with their own quantity being sent to a specific location. 

The Stock_Needed Table will show at which date how many parts are needed.

With the example I have, Part A has 6 Orders Open from 1/1/2021 - 11/1/2021, to total 64. These are individual orders being sent at different dates.

Part A needs a total of 5 of those 64 parts, with 3 needed first on 6/1/2021.  

I want to create a Waterfall Chart that will showcase all of the stock arriving on location, but also highlight the loss of inventory when it is getting taken away.

Something measures I've tried in order to get this figured out.

In order to summarize the key table to produce one value per unique ID - 

Total_PO_Open = SUMX(SUMMARIZE('Key_Table', Key_Table[Part_Number], Key_Table[PO_Key], "POQuantity", MAX('Key_Table'[PO_OpenQuantiy])), ([POQuantity]))

I did the same as above, but for the Stock Needed.

I think my issue is with relating dates, because both of my measures reflect what I'm looking for in a table, but as soon as I bring in the opposite date it goes back to repeating values.

First time posting, so I hope I covered everything.

Thanks!

[MFelix]

Hi @Anonymous ,

Believe that you need to have a date dimension table to grab all the values in the correct dates, however I'm having difficulty in understanding your explanation alongside with the model you have, you talk about a total of 64 for 5 PO but I get 60 not really sure if I'm using the same columns for filtering has you.

can you share a little bit more how you cnostruct your table visualizations, what are the columns you are using?

Also do you know what is the expected look of the waterfall that you need to obtain?

So that I can get the same results and then go from there to help you achieve the correct answer.