SELCT Function

[Mrak123]

Hi All,

I'm having some trouble with a select function, normally they work ok for me but this one is just bringing up a 0 instead of what it should. I have the formula below in the "initial value" field of my [Batch Number] row within my [Received] Table.

ANY(SELECT(Backup[Batch Number],([_ROWNUMBER]=(MAXROW("Backup","_ROWNUMBER")))))

My aim is to make the initial value of [Batch Number] equal to the most recent [Batch Number] of the "Backup" table. But at the moment it is just giving me 0 as the output.

Thanks in advance

[TeeSee1 · Accepted solution]

A quick check..

In the expression, [_ROWNUMBER]=(MAXROW("Backup","_ROWNUMBER")) is matching the rownumber to the 'key' of the table. Do you have your rownumber set to the key of the table?

If not it should be [your key col] = MAXROW("Backup","_ROWNUMBER")

[Mrak123]

@TeeSee1 Genius! Thankyou very much for your fast answer, worked a treat