Forum Discussion
Measure taking forever to execute
Hello everyone I have a reacurring issue I have a measure which calculates the starting id (row number) and the ending id according to some conditions. These conditions change for every row. Aft...
Try to use MIN(), add an index (key) column, see how many blanks you actually have in that column etc. Don't despair!
lbendlin Thanks for your reply
I already have an index column. (The ID column)
I tried inestead of FIRSTNONEBLANK() to use MIN(). It maybe has a slight impact, but its not significant. The 2 measures still take 10+ Minutes to execute. (Sometimes I even get an out of memory error).