0

Creating a formulate based on the caption of the current member for a different dimension

I have two year year dimensions, lets say [A].[Year] and  [B].[Year], I am trying to get the value of the B year based on the selected value of the A year in a slicer. I've tried this with a list formulate with the below but whenever I try it in a discover I just get a server error, would there be a different way to go about it?

 

{StrToMember([B].[Year],CurrentMember([A].[Year]).caption())}

1 reply

null
    • Customer Solutions Architect
    • Moshe_Yossef
    • 2 mths ago
    • Reported - view

    Hi   ,

    Try using: {StrToMember([B].[Year],[A].[Year]CurrentMember.caption())}

    This worked for me.

Login to reply

Content aside

  • Status Answered
  • 2 mths agoLast active
  • 1Replies
  • 31Views
  • 2 Following