Need help to show multiple Years and multiple months in Dynamic Title

[Anonymous]

Hi guys...I have to show multiple years and multiple months in dynamic title from selecting years and months from filter pane.... Currently using the below measure, It is working for a single year and single month.

Dynamic Title =
VAR Title1= SWITCH (
TRUE(),
ISFILTERED('Query1'[DATE].[Month]), SELECTEDVALUE('Query1'[DATE].[YEAR]) &" and Month "& SELECTEDVALUE ('Query1'[Date].[Month]),
ISFILTERED ('Query1'[DATE].[YEAR]), SELECTEDVALUE ('Query1'[DATE].[Year]),
BLANK ())
Return "Balance by Year " & Title1


Can you please help me with this.

[Anonymous]

Hi @Anonymous ,

You can use something like:

CONCATENATEX(Employees, [FirstName] & “ “ & [LastName], “,”)  to return a concatenate string of values, in this sample for instance "Alan Brewer, Michael Blythe" for two records in the Employees table

Jan