Forum Discussion
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...
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
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