Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Please use below expression
FirstSortedValue([C Score],-[C Create Date])
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?
Yes, requirement is like that.
Thanks
@tresesco could you please suggest on this.
Please use below expression
FirstSortedValue([C Score],-[C Create Date])