I wondering if anyone can help me modify the below expression
MAX ( SELECT (LOCAL CATALOGUE PRICES[List Price], [Product Name & Reference] = [_THISROW].[Product Name & Reference]))
I have a date column called [Valid From Date] in the same "LOCAL CATALOGUE PRICES" table
How do I adjust this expression to return value of "List Price" from the row that has the max value in the [Valid From Date] column?
I believe I might need to use the MAXROW function, but I not sure how to and if it is the correct function to use.
So essentially what I trying to do is make sure I always return the latest "List Price" value based on the latest [Valid From Date] value as it not always the case that the MAX [List Price] value is always the latest value.
Hope I making sense.
LinkedIn
Twitter
