topic Re: Previous Period's Value in the Current Period. in App Development

Previous Period's Value in the Current Period.

Shahith — Thu, 23 May 2024 05:08:44 GMT

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.

Re: Previous Period's Value in the Current Period.

MeehyeOh — Thu, 23 May 2024 05:34:19 GMT

Hi, @Shahith

Try Above function

Reply, thanks!

Re: Previous Period's Value in the Current Period.

Shahith — Thu, 23 May 2024 06:06:57 GMT

Yes, it worked. Thank you so much!!

Have a good day!

Re: Previous Period's Value in the Current Period.

Shahith — Tue, 28 May 2024 06:07:07 GMT

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!

Re: Previous Period's Value in the Current Period.

MeehyeOh — Wed, 29 May 2024 04:37:25 GMT

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)

Re: Previous Period's Value in the Current Period.

Shahith — Wed, 29 May 2024 05:59:34 GMT

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!!