Forum Discussion
Optimizing Calculated Column for approx 2million Rows of Data
I attempted the modified formula you suggested. Unfortunately, I was still stuck on 'Working On It'. I let it run for at least 10 minutes before just force closing PowerBI. However, for this iteration of the formula, I noticed that my memory usage did not spike like it did with my initial attempt.
As for my intent, here is a snippet of my data table as it may better explain what I'm trying to accomlish (I originally ommitted the [skill_name] column):
Here is what I would like to accomlish with this calculated field:
For each [skill_name] = "Tech Support ACB", give me a count of (imagine each point as an 'AND' statement):
- [ANI_DIALNUM] matches the [contact_name] of each skill_name 'Tech Support ACB'
- [start_datetime] is between the [start_datetime] and [end_datetime] of each skill_name 'Tech Support ACB'
- [Contact Type]="Inbound Call"
Once I have this calculated field, I could then create a simple measure to calculate the percentage of Tech Support ACB skills that were transferred (i.e. have a count >1). It is not possible for another Tech Support ACB to be counted within the count of each ACB which is why I have everything in one table.
I am not opposed to other ideas. If you have a measure in mind that would allow me to accomplish my intent without having to create a calculated field, I'm all ears.
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.
- gra_wang8 years agoHelper I
Sent you a PM