Sort expression

[T-Shigenori]

Please tell me about the Expression function to sort [Name] in the table "test" in ascending order by [number] in the same table.
Note that ORDERBY(test[Name], [number], TRUE) requires that [Name] be a key value, but [Name] is not a key value. What should I do?

[Arni_Kli]

You can corresponding two tables by copying [Name] to first table by link or by formula in virtual column or by action or bot and then sort this (first) table by [Name] as you want

ORDERBY(Test[Unique_ID], [Name]) 

[T-Shigenori]

supplementally, in case of  [NAME]  column that set  ENUMLIST ,

I want to display  [name] list that is another table and sorted by [number] that is in the same table. 

the table name I want to display   [name] sorted by [number] is "BR"

the table name that [name] and [number] column are in is "test"

I added  orderby(test[name],test[number], true]

in the valid if expression.

ot doesn't work...

[Steve · Accepted solution]

Build list dereferences