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")