Need to Display Date Based on Ledger Value

[Lakshminarayanan_J]

Hi Expert,

We need to Display Based on Ledger Value , 

For Example:

Ledger Value is Minimum Need To display Arrival Date

Ledger Value is Maximum Need to display Delivery Date

Expected Result Based on Below Table:

Need To Display Arrival date based on minimum ledger value : 28-12-2022 

Need To Display Arrival date based on Maximum ledger value : 30-12-2022 

Table: 

Ledger Value	Arrival Date	Departure Date
1	28-12-2022	31-12-2022
2	26-12-2022	29-12-2022
3	27-12-2022	26-12-2022
4	29-12-2022	25-12-2022
5	30-12-2022	28-12-2022
6	31-12-2022	30-12-2022

[BrunPierre]

Min:  =FirstSortedValue([Arrival Date],[Ledger Value])

Max: =FirstSortedValue([Arrival Date],-[Ledger Value])

[Lakshminarayanan_J]

@BrunPierre 

Thank You For Your Response,

 I have tried implementing for Min as you mentioned above, But is it displaying all three IDs

For ID:s22023 , we have 3 ledger value , but need to display only min , which is 1 and date as 6/18/2022 not all three values

Ledger Value	ID	=date(FirstSortedValue([Transport ATA],[Transport Ledger Order]))
1	S22023	6/18/2022
2	S22023	6/22/2022
3	S22023	6/26/2022

[BrunPierre]

Share the dataset with all the necessary columns.

[Lakshminarayanan_J]

@BrunPierre 

this is the Adhoc report, primary column is ID

[BrunPierre]

=FirstSortedValue(Aggr(Only([Transport ATA]),ID,[Ledger Value]), [Transport Ledger Order])