topic Re: Dynamic name in DAX Commands and Tips

Dynamic name

homelander123 — Thu, 13 Feb 2025 22:37:41 GMT

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.

Re: Dynamic name

Punithurs — Fri, 14 Feb 2025 01:33:11 GMT

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

Re: Dynamic name

lbendlin — Fri, 14 Feb 2025 02:36:14 GMT

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

Re: Dynamic name

homelander123 — Fri, 14 Feb 2025 03:46:08 GMT

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

Re: Dynamic name

lbendlin — Fri, 14 Feb 2025 11:41:41 GMT

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

Re: Dynamic name

homelander123 — Fri, 14 Feb 2025 14:21:48 GMT

Punithurs It says syntax incorrect

Re: Dynamic name

lbendlin — Fri, 14 Feb 2025 14:52:08 GMT

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

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

Re: Dynamic name

Anonymous — Tue, 18 Feb 2025 08:18:08 GMT

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.