Forum Discussion
Solved
Dynamic name
CurrentMonthLastYearCount = VAR SelectedMonth = MAX(Query1[SetupDate]) VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -13) + 1 VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12) VAR Resu...
Your solution is so great Punithurs and lbendlin
Hi, homelander123
I think you can refer to this blog post from the community below:
Dynamic titles in Power BI - Microsoft Fabric Community
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi homelander123 ,
Hope your Question is to show the title dynamically when a slicer selection is made,
Measure =
VAR SelectedMonth = MAX(Query1[SetupDate])
VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -13) + 1
RETURN
FORMAT(LastYearSameMonthStart,"MMM") & " " YEAR(LastYearSameMonthStart)
Use this Measure as function in visual title.
If this is not what your looking for, please elobrate your ask.
Thanks,
Punith
Punithurs It says syntax incorrect
CurrentMonthLastYearCount = CALCULATE( SUM(Query1[NewCount]), SAMEPERIODLASTYEAR(Dates[Date]))This assumes that you have a proper calendar table "Dates" is your data model.
