I have evaluated a single row using TopN(1,table,expression). Now I want to use that in a calculated column by extracting a specific column from the row set. How would I do that? An alternative approach I have considered is to use Values(filter(table,rowsIwant)) but a similar problem is how do I change a column into a scalar value, assuming I can guarantee one row returned.
A simpler way of saying it, is how to I get the most recent value of X for customer Y and put that as a calculated column on all of Y's rows.
- Pete
A simpler way of saying it, is how to I get the most recent value of X for customer Y and put that as a calculated column on all of Y's rows.
- Pete