Time: PREVIOUS vs ITEM(TIME) - 1

Hi all,

 

What's your opinion, should I ever use PREVIOUS(ITEM(TIME)) function when ITEM(TIME) - 1 does the same thing?

KirillKuznetsov_0-1628868716345.png

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:

  • PREVIOUS(NUMBEREDVALUE)

OR

  • combination of having ITEM(TIME) - 1 and NUMBEREDVALUE[LOOKUP:'ITEM - 1'] ??

Let me know your thoughts.

 

Cheers!

 

Answers