Water Cooler

[kishorj1982]

Hi All,

I want to  find the recent value (on Child Id) for each Parent Id within a selected date range (e.g. MTD).

Could you please suggest how to proceed.

I have attached sample the data set for this and I have highlighted the part that we need in output.

I tried with first sorted value but no luck.

Could you please suggest.

Thanks

[shiveshsingh]

Hi

If i see your data, what do you mean by recent value? is it based on C Create Date?

If parent Id is 1, then recent child id will be C_1_5?

[kishorj1982]

Yes, requirement is like that.

Thanks

[kishorj1982]

@tresesco could you please suggest on this.

[shiveshsingh · Accepted solution]

Please use below expression

FirstSortedValue([C Score],-[C Create Date])