calculated columns are not updating after adding new data

[Deborah1982]

Hi,

I need some help.

I have a calculated field, there is no way I can update them with new data?

For example:

I have an excel with 4 tabs: 2013 - 2014 - 2015 - 2016

I have uploaded those 4 tabs in BI.  I have append all tables into 1 big table.  So I have all data from year 2013-2016.

I have added some columns with calculations.  For example to calculate total profit, total proc price, etc......

This is working perfectly.

I have now next tab in xls: 2017

I have uploaded this in BI, and append this data in the big table.  This was all working BUT the extra fields I had created does not contain any data for 2017 (total sales, total profit, etc....).

How can I change this without deleting the whole column and create this again? (I have done this for this time)

There are a lot of charts and tables created with special filters, if I have to create the columns all over again, each time I have new data, it will consume a lot of time, if I take the wrong title, all my charts/tables will be corrupted.

Does someone has a solution for me?

I have looked into older topics, but could not find the same issue, that would help me.

[Vvelarde]

@Deborah1982

Are you creating this column in Query Editor?. if the answer is Yes. You can move these actions after the Append Action.

This is sample:

In Query Settings

[Deborah1982]

Hi,

Yes I'm doing this in the Query Editor.

This is what I now have after adding the 'new data'.

So what should I do?

So what should I do?

[Vvelarde]

@Deborah1982

I try moving Append Query before the first Added Custom.

[Deborah1982 · Accepted solution]

Thanks it worked!