Team, 

I have the calculation below doing comparison between Current and Previous members of a Fiscal Date Dimension. 

The issue that I have is, when I pick 2014 and 2015, this shows the comparison between 2013/2014 and 2014/2015, while I expect only to see the comparison between the current members (2014/2015). 

What can I do in order to achieve the above?

(
[Ship Date - Fiscal].[Year - Fiscal].CurrentMember,[Measures].[Line Total - Unformatted])-
([Ship Date - Fiscal].[Year - Fiscal].PrevMember,[Measures].[Line Total - Unformatted]
)

Hi RealSQLSantos,

According to your description, you only want to get the comparison of 2014 and 2015. Right?

Based on your expression, it will evaluate the current member your pick and the previous member. So when you pick 2014, it will get fact data for 2014 subtract fact data for 2013. When you pick 2015, it will evaluate 2015 subtract 2014. That's why your get two comparison. In your scenario, if you only want to compare 2015 and 2014, you only need to pick 2015.

Reference:
CurrentMember (MDX)
PrevMember (MDX)

Regards,