Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
How about this
=Min({<[Cust_Balance]={"$(=Min(Cust_Balance))"}>} [Cust_date])
or this
FirstSortedValue(Cust_date, Cust_Balance)
How about this
=Min({<[Cust_Balance]={"$(=Min(Cust_Balance))"}>} [Cust_date])
or this
FirstSortedValue(Cust_date, Cust_Balance)
The first expression is no better than the one I was using. However, the FirstSortedValue works! Thanks.