Skip to Content
0
L K
Aug 14, 2023 at 12:42 PM

Min date measure value for each id

93 Views

Experts,

I have a scenario as in below tables.

Table(1) - shows the source data.

Table(2) - Shows the generated result.

But I need the result as in Table(3). Expected is : Amount based on minimum date of each ID. Tried by applying 'foreach' and 'in' but no luck.

Table(1)

image.png

Table(2)

image.png

Table(3)

image.png

Thanks in advance.

Attachments

image.png (5.9 kB)
image.png (4.4 kB)
image.png (2.7 kB)