Forum Discussion

mrclay82's avatar
mrclay82
Icon for Helper II rankHelper II
3 years ago

Alternative to TREATAS

Hi all,   I have this measure using TREATAS to calculate on a different date column. The problem is that it is beyond slow. It slows down the whole report.   Are there any alternatives to TREATA...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi mrclay82 

the alternative is usually INTERSECT function or IN operator but that wouldn't improve the performance significantly. In order to optimize your code you need to provide more context and more details about your data model and the measure being calculated perhaps we can find a totally different approach.