Getting the value of a column with one Virtual Column

[Cameron_Brown1]

Hey,

I have an app and I’d like to get the value of a column of the most recent entry in the table. I only seem to be able to do it using two virtual columns - one to get the reference to the row, and one to get the column’s value. Is it possible to do both at once?

I currently have a column with:
INDEX(ORDERBY(SELECT(Grape Samples[DateTime]), "DateTime"), 1)
And a column with:
[Most Recent Entry].[Variety]
Which references that first column.

I seem to be unable to do it all in one, like this:
INDEX(ORDERBY(SELECT(Grape Samples[DateTime], true), "DateTime"), 1).[Variety]
which I assumed would work but it does not.

Is this just not possible? Or could it be unintended?

Thanks

[Aleksi]

Try something like…
LOOKUP(MAXROW(“Grape Samples”,"_rownumber"),“Gray Samples”,“KeyColumn”,“Variety”)

[Steve]

Cameron_Brown:

I seem to be unable to do it all in one, like this:
INDEX(ORDERBY(SELECT(Grape Samples[DateTime], true), "DateTime"), 1).[Variety]
which I assumed would work but it does not.

That syntax isn’t supported, unfortunately.