Forum Discussion
Create a custom measure for a title using min and max dates
Hi there I have a dynamic title which shows the time period a user is looking at based on the period they've selected from my date slicer. The measure looks like this: Title Sub Report = "CUR...
Anonymous
You can put it this way as well:Title Sub Report = "CURRENTLY VIEWING MONTHS " & FORMAT(MIN('DimReportingPeriod'[Reporting Period]),"mmmm yyyy") & " TO " & FORMAT(MAX('DimReportingPeriod'[Reporting Period]),"mmmm yyyy")________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy
Super User
Super UserAnonymous
You can put it this way as well:
Title Sub Report = "CURRENTLY VIEWING MONTHS " & FORMAT(MIN('DimReportingPeriod'[Reporting Period]),"mmmm yyyy") & " TO " & FORMAT(MAX('DimReportingPeriod'[Reporting Period]),"mmmm yyyy")________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Faaabulous I didn't realise you could use FORMAT in this way, I will for sure be using it again! Thanks so much Fowmy