Forum Discussion
Performance Impact with Calculated Columns
Calculated Columns are not dynamic (unless you are in Direct Query mode) - they are pre-calculated and stored. Custom Columns from the Query Editor are similar, but the performance is marginally better. I lean towards them for that reason but mainly because they are much easier to write, debug and test.
Calculated Columns are not dynamic (unless you are in Direct Query mode) - they are pre-calculated and stored. Custom Columns from the Query Editor are similar, but the performance is marginally better. I lean towards them for that reason but mainly because they are much easier to write, debug and test.
Thank you so much for responding!
I am glad that my initial assumption were right about data getting stored! :)
I went ahead and created all caclulated queries because the amount of data imported was already huge. People at work started questioning about the performance and thats why I wanted to get it clarified here.
Thank you so much! I will mark your response as Solution. :)
"I lean towards them for that reason but mainly because they are much easier to write, debug and test. "
Did you mean Custom columns or Calculated Columns??
I meant Custom Columns from the Query Editor.