ENUM to list the data start from recent row to the top row?

[Jayz_c]

How can i set the vaild if in ENUM to list out the data start from recent row to start row (From Row 7 to Row 2 )?

Table name: Database

Column name: ID

[Steve · Accepted solution]

ORDERBY(Database[ID], [_RowNumber], TRUE)

See also: ORDERBY()

[Jayz_c · Accepted solution]

Hi Steve, following up on your previous answer about ENUM validation from Row 7 to Row 2

I forgot to mention that the ID column in my Database table is NOT a key/primary key column. How would I modify the validation to list data in reverse order (recent rows first) when the identifier column isn't a unique key? 

Could you help adjust the solution? Thanks! 

Additional context: 

• Table: Database 

• Column to order: ID (non-key, non-unique values) • Desired order: Start from newest row (Row 7) backward to older rows (RoW 2)

[Steve · Accepted solution]

ORDERBY(Database[ID], [_RowNumber], TRUE)

See also: ORDERBY()

[Jayz_c · Accepted solution]

Hi Steve, following up on your previous answer about ENUM validation from Row 7 to Row 2

I forgot to mention that the ID column in my Database table is NOT a key/primary key column. How would I modify the validation to list data in reverse order (recent rows first) when the identifier column isn't a unique key? 

Could you help adjust the solution? Thanks! 

Additional context: 

• Table: Database 

• Column to order: ID (non-key, non-unique values) • Desired order: Start from newest row (Row 7) backward to older rows (RoW 2)

[Steve · Accepted solution]

In this case, you must add a(n optionally virtual) column with the ORDERBY() expression above, then dereference that column to get the non-key column values. So if the column with the ORDERBY() expression is named Ordered rows and the desired value is in the column named Wanted column, you could use the expression, [Ordered rows][Wanted column].

[Jayz_c]

Hi Steve,

Just wanted to say a huge thank you! Your solution worked perfectly, it's exactly what I needed. You’ve been a massive help! 🙌

Really appreciate your time and expertise!