Forum Discussion

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

Amounts not showing Correctly

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 ...
Need Help
Show and Tell
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

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

edavila's avatar
edavila
Icon for Helper II rankHelper II
9 years ago

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's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    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's avatar
    edavila
    Icon for Helper II rankHelper II
    9 years ago

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

     

    thanks