Kibong Kang Posted May 21, 2023 Share Posted May 21, 2023 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 More sharing options...
Solution Gaia Paolini Posted May 22, 2023 Solution Share Posted May 22, 2023 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]) Link to comment Share on other sites More sharing options...
Kibong Kang Posted May 24, 2023 Author Share Posted May 24, 2023 Thank you so much!it is work for best! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now