Dynamic title Based on Date

Question

How to Create a Dynamic Title Based on Date:

Dynamic title, Ex Period:,, dd/mm/yyyy - ,,dd/mm/yyyy

when user select date it is dynamically change. How to create a dax calculation.

Dynamic - DD/MM/YYYY

Answer 1

Hi, @Vnk,

You can try this:

[Date(WindowMax)(Title)] = WINDOW_MAX( MAX( [Date] ) )

[Date(WindowMin)(Title)] = WINDOW_MIN( MIN( [Date] ) )


-Right-Click the calculated field  and go in Default Properties - Date Format  to set the Date formating


-Bring both on the Detail shelf  and edit your Title

from:<AGG(Date(WindowMin)(Title))>  to:  <AGG(Date(WindowMax)(Title))>