Forum Discussion
Converting UTC to Local Time Without Adding New Columns or Using DAX
It's a little bit 'clunky' but you could simply remove the donor columns after creating the duplicated/converted columns, so you would end up with the same number of columns as you started with. You could also rename the new column to the name of the donor column after removing it, so your column names would remain constant.
GazzerThank you for your response, however we are curious would deleting the original date columns at the end of the query still maintains the complexity issues of our tables since the query would still need to calculate all of the duplicate date columns even if they are removed at the end of the query?
The reason we would like to avoid this in general is that we have tables with 2-3 million rows and already 10-15 columns so it takes a long time to refresh our data, and we are similarly worried about the impact the calculation of several custom columns may have on our memory.
Kind Regards,
Kaden
I'm sorry, but I don't know what kind of memory impact you will experience here - I can only suggest to try it and measure the effect.