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

[lsullivan6311]

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.

[pi_eye · Accepted solution]

Hi @lsullivan6311 

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