Max Date

[Dayna]

Hello,

I have a query, I am trying to show min data for the max date within chart. The chart using set analysis works out the last 13 and next 13 weeks stock, but one week may have multiple records, and some multiples on the same day. I want to show the balance for the last (max day) but the minimum value.

So far, I have:

=Minstring({<[BOM Chart - Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>}[BOM Chart - Balance])

Which works out the min value for the last and next 13 weeks, but I cant work out how to include the MAX day.

Something like, Max(Date(Minstring({<[BOM Chart - Date] = {"<=$(=date(only(today())+91))>=$(=date(only(today())-91))"}>}[BOM Chart - Balance]) )??

If anyone could help me with this, it would be most appreciated!!!!!

Kind Regards,

Dayna