I want to get the last value of a particular group through the calculated column.

[Kibong Kang]

Columns in a specific table have product ID, production time, process name, and target value.

​

I want to display the target value of the value with the largest production time among the values with the same product ID and process name on all rows.

​

I Made that first formula was successful in getting the target with the oldest production time among rows with the same product ID.

Concatate([Target Value]) OVER intersect([Product ID], Last(Production Time]))

Adding the process name to the above formula does not produce the desired value.

How do I write an expression to get the value I want?

[Gaia Paolini]

Your original formula threw an error for me, I think because Last does not work after Over.

Can you try this:

ValueForMax([Production Time],[Target Value]) over ([Product ID],[Process Name])

[Kibong Kang]

Thank you so much!

it is work for best!