Jump to content

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

Kibong Kang
Go to solution Solved by Gaia Paolini,

Recommended Posts

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?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...