Amounts not showing Correctly

[edavila]

I have 2 tables one that has all the dates from 2 years listed and also the name of the month, week and year

and I create a report as table to show the Balance sheet for the company at a certain point of taime Jan or February so far, the balance on the table is correctly with my financial statements, but when I create a line chart and add the week on the Axis the balance that shows is the last amount for that week instead of adding all the amount for the Year to date. or even if I put the month will show the last amount for the month not the correct balance

[parry2k]

as @Vvelarde mentioned, you can still have seperate sheet but you can combine those in PowerBI using Append.

[edavila]

Thank you and know I run into another problem as I combine both sheets into one and my number does not show for each year as separated and they are cero as no conection has between them.

know what I think has to be done here is create a new column and just add and IF formula to get everything that belong to 2016 into that column and another for the 2017 as well, Im correct

Thanks

[parry2k]

I looked at your sheet, and you renamed amount to amounr 2016 and amount 2017 respectively, just don't rename those columns, leave it as amount and then use append query.

basically what you want is FY 2016 is append to FY 2017 (or vice versa) and all the rows are appended to existing table and not added as extra column, 

[edavila]

PArry2k

now is adding correctly but all the accounts are mess up as instead of gruping like before they sread all over and the cash balance is ok but I cannot set it up as a line chart

https://www.dropbox.com/sh/0bfiodh0vaid65l/AAD0OHEpSkttRdrEzT22mazca?dl=0

[edavila]

I was able to put amount on the 2016 -2017 but the cash graph is not working

thanks