Forum Discussion
Optimizing Calculated Column for approx 2million Rows of Data
I have the following columns: refCallDetail[ANI_DIALNUM], refCallDetail[contact_name], refCallDetail[Contact Type], refCallDetail[start_datetime], refCallDetail[end_datetime] each with pre...
HI gra_wang
If you can obfuscate your data and share it privately, I can do a better job at trying to optimise over the actual data for you.
I'd still recommend a calculated column over a calculated measure for this. You only want the calculation to run once, rather than everytime a user does something on your report.
Sent you a PM