$ sign expansion not working

[dwfiv327]

I have a table of account balances and dates for each.  I can find the minimum and maximum balance easily, but I also want to show when that minimum or maximum was reached.  I have tried several variations on this expression to no avail.  Can some one please let me know what is missing in my set expression?  The expression editor says that this expression is OK, but it returns no results.

=Min({<[Cust_Balance]={$(=Min(Cust_Balance))}>} [Cust_date])

[sunny_talwar · Accepted solution]

How about this

=Min({<[Cust_Balance]={"$(=Min(Cust_Balance))"}>} [Cust_date])

or this

FirstSortedValue(Cust_date, Cust_Balance)

[dwfiv327]

The first expression is no better than the one I was using. However, the FirstSortedValue works!  Thanks.