Cash Flow Forecast in Power BI

[Anonymous]

I am building a cash flow forecast in Power BI, and unfortunately it's not performing as expected. I am trying to create a table visualization, and then I will build a corresponding chart.

The table is currently showing:

However, I would expect (this was a quick build by me in Excel to show my end goal): 

I have a date master table which I am using to populate the "Cash Date" column. It looks like this: 

The data in the Bank Balance table looks like this: 

The data in the Bills table looks like this: 

The data in the Invoices table looks like this: 

Finally, I have checked my data relationships, and they seem to be appropriate: 

Summary:

The first screenshot is what I am receiving when I create a table visualization in Power BI. The second screenshot is what I put together in Excel, outside of Power BI, and what I am trying to achieve based on the data in the Bank Balance, Bills and Invoices tables.

My original hypothesis, based on videos I've watched, was that my data relationship(s) was incorrect. However, based on the last screenshot that doesn't seem to be the case.

Thanks in advance for any help!

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may try Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to create a new table.