Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dynamic title selected value Table.[YearMo].[Month] & selected value Table.[YearMo].[Year]& prior yr

I have a visual that is filtered based on:

 Table[YearMo].[Month]

 Table[YearMo].[Year]

 

Current dynamic title measure =

 

TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year]

which returns:    For Twelve Months Ended December, 2022   (Example for last month)

 

I want it to return:        For Twelve Months Ended December, 2021 and 2022

 

I have made a dynamic title with these two date filters, but how do I include the prior year as well?  There is not a filter for that.

 

Need Help
  • pi_eye's avatar
    pi_eye
    3 years ago

    Hi Anonymous 

     

    The simplest way would probably be to subtract 1 from the year, and concatenate that into your string.

     

    TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year])-1 & " and "  & SELECTEDVALUE(Table[YearMo].[Year])

     

    Does this work for you?

     

    Pi

1 Reply

  • pi_eye's avatar
    pi_eye
    Resolver IV
    3 years ago

    Hi Anonymous 

     

    The simplest way would probably be to subtract 1 from the year, and concatenate that into your string.

     

    TitleDetail = "For Twelve Months Ended " & SELECTEDVALUE(Table[YearMo].[Month]) & ", " & SELECTEDVALUE(Table[YearMo].[Year])-1 & " and "  & SELECTEDVALUE(Table[YearMo].[Year])

     

    Does this work for you?

     

    Pi