Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Hopefully this is an easy one.....
My dimensions are:
Year (2009, 2010 etc.)
Year & Month (2009 Jan, 2009 Feb etc.)
Year & Month_mm (2009 01, 2009 02 etc.)
When a user selects from Year, I want the min of Year & Month to be displayed. I can't use min(Year & Month) because it's a text field, I can't use minstring(Year & Month) because it always returns xxxx Apr.
Is it possible to use indirect set analysis using the min of Year & Month_mm but return the value from Year & Month?
I'm having a complete mind-block on this one so hopefully someone will provide the solution.
Many thanks.
=ONLY({1<[IPSM Year & Month_mm] = {'$(=min([IPSM Year & Month_mm]))'}>} [IPSM Year & Month])