Question about Updating Data

[Anonymous]

Hi,

I have a main sales table that has to updates every month, so the source file that populates the sales table would have more data every month, this means every month when the file gets more data, the sales table should also be updated with more data. My question is that I want to create some calculated columns on the sales table, will these calculated columns still work once the sales table gets updated?

Thanks.

[v-zhangti]

Hi, @Anonymous 

If your data table is on the large side, it is recommended to use measure calculation. Similarly, the calculation will remain in effect as long as the columns in the calculation are not deleted and renamed.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johncolley]

Hi @Anonymous , It will continue to work, as long as the fields used in the calculated column aren't removed or renamed.