Time: PREVIOUS vs ITEM(TIME) - 1
What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing?
Best Practice says it's not recomended to use PREVIOUS() due to low performance.
In the example above it is probably straightforward "yes" to ITEM(TIME) - 1 approach. But what about when there is some "numbered value" and you have to choose between:
- combination of having ITEM(TIME) - 1 and NUMBEREDVALUE[LOOKUP:'ITEM - 1'] ??
Let me know your thoughts.