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.

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

[MeehyeOh · Accepted solution]

Hi, @Shahith 

Try Above function

Reply, thanks!

[Shahith]

Yes, it worked. Thank you so much!!

Have a good day!

[Shahith]

Hello,

How can we achieve this in Data Load Editor? Both the fields(FiscalPeriod and Claims Count) are from the same table.

Thanks in advance!

[MeehyeOh · Accepted solution]

Hi, @Shahith 

First of all, I don't know your data set in detail, so I don't know if it will be a solution.

As in the image attached below, try left join the data that adds one month to the yearmonth in the existing table.
When resident the dataset for left join, you need to add the necessary conditions to the "where".

(Please expand the image and check it out)

[Shahith]

Hello @MeehyeOh , Thank you so much for putting in the effort to help me, the above approach worked as expected, and now I got the desired output.

Have a Good Day!!