Get the column value from a row

[paivers]

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

 

[GDRIII]

Would =IF([customer]=Y,CALCULATE([x],customer=Y),BLANK())) or something like that work?

 

[scottsen]

IF you know you have exactly 1 row in a table, VALUES() is certainly the way you covert it to a scalar. Depending on your specific scenario that might be used with LASTNONBLANK/TOPN/FILTER/LOOKUPVALUE/...