ORDERBY by date - question

[Aurelien]

Hi Community,

I had a look to many posts and documentation but I don’t get why my expression does not gives the expected result.

I have a list of ID related to a table of prices, which contains [DATE] column (type Date) and I want to sort this ID list by their date.
The final purpose is to get the most recent price.

To achieve that, I use a FILTER expression so that I’m sure I will get a list of key-columns values, and use ORDERBY expression to sort this list according to the date.
The next step will be to use TOP() Expression.

Here is the “basic” expression: defaultPrice_TEST_per1

FILTER(
	"PRIX VENTE",
     AND(
		[Devise]="€",   
          [Qté Lot]="1", 
     	[ID REF]=[_THISROW].[related_ID_Object]
          
     )
)

Here is the “sorted” expression: defaultPrice_TEST_per1_orderedByDate_TRUE

ORDERBY(
  FILTER(
       "PRIX VENTE",
       AND(
            [Devise]="€",   
            [Qté Lot]="1", 
            [ID REF]=[_THISROW].[related_ID_Object]

       )
  ),
  [DATE],
  TRUE
)

And the output I got, which does not make sense to me:

Because of this, I didn’t try the TOP() yet because I need my previous expression to give the expected result.

Any clue on how to achieve what I want ?
Or, the list is sorted but this is just a matter of preview display ?

Many thanks in advance