Stacked Column Chart - including data from table with two different date columns

Hello,

I have a Power BI report with 3 maine tables: PA, NAV and  Date. The date table is used to filter by year in my report, therefore, all the other tables are connected to it through their Date column.

However, the PA report has a second date column called "date updated". 

What I try is to build a stacked column chart where on the Shared axis I have the date and in the column axis I have two values: The "Total Amount" from the NAV table and on top of it, the "Upcoming Amount" from the PA table. The trick is that since my PA dataset is a panel data where every month new data is added,  I would like the Upcoming amount to be split by "date updated".  

So what I would like si to have the two figures below in one single graph, on top of each other. Of crouse, the PA table only has data from August, September and October and that's ok. I tried this method: https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/, but a measure will not work since I use some additional filters on my page.

Thanks for trying to help.