Hi,

I'm confused... because FID is passing the correct value I.e July 2012 in both the measures but while displaying this via [Measures].[First Invoice Date2] shows correct result (I.e. July 2012) but it gives the wrong value (Jan 2011) with the [Measures].[First Invoice Date1] 🙁

Again the [Measures].[First Invoice Date2] displays value using set test but the [Measures].[First Invoice Date1] directly used StrToMember('[Time].[Fiscal Hierarchy].&['+ CSTR([Measures].[First Invoice Date].VALUE) +']')

MEMBER [Measures].[FID] AS

Head(

NonEmpty(

EXISTING [Time].[Fiscal Hierarchy].[FiscalMonth].Members,

([Measures].[JBA Sales Quantity])

),

1

).Item(0).properties("key", TYPED)

MEMBER [Measures].[First Invoice Date]AS

MIN(NonEmpty(

(

{[Articles].[Coalition Brand].currentmember} *

{[Customer].[Sold To Country].currentmember}*

{[Local Currency].[Currency].[Currency]}

),[Measures].[FID]),

[Measures].[FID])

Set test

as StrToMember('[Time].[Fiscal Hierarchy].&['+ CSTR([Measures].[First Invoice Date].VALUE) +']')

MEMBER [Measures].[First Invoice Date1]

as test.item(0).name

MEMBER [Measures].[First Invoice Date2]

as StrToMember('[Time].[Fiscal Hierarchy].&['+ CSTR([Measures].[First Invoice Date].VALUE) +']').name

Regards,

Amit J