Forum Discussion
Dynamic name
CurrentMonthLastYearCount =
VAR SelectedMonth = MAX(Query1[SetupDate])
VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -13) + 1
VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12)
VAR Result = CALCULATE( SUM(Query1[NewCount]), Query1[SetupDate] >= LastYearSameMonthStart && Query1[SetupDate] <= LastYearSameMonthEnd )
RETURN
Result
I am using this DAX however i want the name to be dynamic based on slicer selection.
E.g. if i select feb 2025, it should show feb 2024.
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.
7 Replies
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,
PunithPunithurs 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.
That's a lot of code. Have you considered using SAMEPERIODLASTYEAR instead?
I would want that since its not just that. i want it to show for other measures as well. What would be the code?
FORMAT(EDATE(DATES[DATE],-12),"MMM YYYY")
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.
