Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Deborah1982
New Member

calculated columns are not updating after adding new data

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.

1 ACCEPTED SOLUTION

Thanks it worked!

View solution in original post

4 REPLIES 4
Vvelarde
Community Champion
Community Champion

@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 SettingsIn Query Settings

 

 




Lima - Peru

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?So what should I do?

@Deborah1982

 

I try moving Append Query before the first Added Custom.




Lima - Peru

Thanks it worked!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.