Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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:
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?
Thanks it worked!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |