Previous Period's value in the current period.

[Shahith]

Hello,

In the below picture, I have 2 columns, one is Fiscal Period as a Dimension and Claims Count as a measure(both the columns are from the same table).

I need to display the claims count for the period 2024004 as '7'(i.e. 2024003's claim value), and for 2024003 the claim value should be '8' and so on for all the periods.

I got a reply previously for the same question, which is to use the "Above" function, it worked as expected in Chart, but how can I achieve the same in the data load editor?

How can we do that? Any help is greatly appreciated.

[brunobertels]

Hi 

Have a look to the previous and peek function in the help menu 

Previous 

Peek 

[anat]

peek( 'Sales',-1 )  - returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).