How to Create Dynamic Titles in Power BI


ReportTitle = "Reports For " & FORMAT(MIN (DIA_Interactions[VisitedDate]),"dd mmmm yyyy") & " to " & FORMAT(MAX (DIA_Interactions[VisitedDate]),"dd mmmm yyyy")


ReportTitle = 
VAR firstVisitedDate = MIN (DIA_Interactions[VisitedDate])
VAR year = YEAR(firstVisitedDate)
VAR month = MONTH(firstVisitedDate)
VAR startDate = DATE(year, month, 1)
VAR endate = EOMONTH(startDate, 0)
RETURN                                                                                                                                                                                                                                                            
	"Reports For " & FORMAT(startDate,"dd mmmm yyyy") & " to " & FORMAT(endate,"dd mmmm yyyy")