Dynamic name

[homelander123]

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. 

[Anonymous · Accepted solution]

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.

[lbendlin]

FORMAT(EDATE(DATES[DATE],-12),"MMM YYYY")

[homelander123]

I would want that since its not just that. i want it to show for other measures as well. What would be the code?

[lbendlin]

That's a lot of code.  Have you considered using SAMEPERIODLASTYEAR  instead?

[Punithurs]

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

[homelander123]

@Punithurs It says syntax incorrect

[lbendlin]

CurrentMonthLastYearCount =
CALCULATE( SUM(Query1[NewCount]), SAMEPERIODLASTYEAR(Dates[Date]))

This assumes that you have a proper calendar table "Dates"  is your data model.