Find the earlist value(s) with List display

[LawrenceMa]

Hello,

I have a table includes 6 columns and 2 virtural columns [Earliest Date] & [Earliest Model(s) Available] below:

The virtural column [Earliest Date] uses min() function which works perfectly.

The virtural column [Earliest Model(s) Available] trys to find out the earliest date between [1st Date], [2nd Date] & [3rd Date] and then figures out Model(s) name.

What I tried app formula in virtural column [Earliest Model(s) Available] (type: List) but doesn't work properly:

LIST(
ANY(SELECT([1st Model]
, [_THISROW].[Earliest Date] = [_THISROW].[1st Date])),
ANY(SELECT([2nd Model]
, [_THISROW].[Earliest Date] = [_THISROW].[2nd Date)),
ANY(SELECT([3rd Model]
, [_THISROW].[Earliest Date] = [_THISROW].[3rd Date]))
)

Any thoughts on how can I rewrite above formula to get the earlist model(s). Thank you.

@Steve @Joseph_Seddik @Marc_Dillon @Suvrutt_Gurjar @Rafael_ANEIC-PY @Koichi_Tsuji 

[Rafael_ANEIC-PY · Accepted solution]

Hello @LawrenceMa, try this expression:

LIST(
IF([Earliest Date]=[1st Date],[1st Model],""),
IF([Earliest Date]=[2nd Date],[2nd Model],""),
IF([Earliest Date]=[3rd Date],[3rd Model],"")
)
- LIST("")