topic Re: Dax Query Not working in DAX Commands and Tips

Dax Query Not working

homelander123 — Thu, 13 Feb 2025 17:28:00 GMT

CurrentMonthLastYearCount = VAR SelectedMonth = MAX(Query1[SetupDate]) VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -12) + 1 VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12) RETURN CALCULATE( SUM(Query1[NewCount]), Query1[SetupDate] >= LastYearSameMonthStart && Query1[SetupDate] <= LastYearSameMonthEnd )

I am trying to write a query which shows current month last year in my matrix based on slicer date selection but this query wont return any reuslts and would show up as blank

Re: Dax Query Not working

Greg_Deckler — Thu, 13 Feb 2025 18:56:54 GMT

homelander123 I think you want this:

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

Re: Dax Query Not working

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

This works. Thank you so much. Can you please tell me how can i make the name dynamic to the slicer. E.g, if i have selected feb 2025 it should show feb 2024

Re: Dax Query Not working

homelander123 — Thu, 13 Feb 2025 22:32:46 GMT

Greg_Deckler

Re: Dax Query Not working

Greg_Deckler — Fri, 14 Feb 2025 15:13:46 GMT

homelander123 If I understand what you are saying, you could do something like this and put it in a Card visual:

Measure = VAR SelectedMonth = MAX(Query1[SetupDate]) VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12) VAR Result = FORMAT( LastYearSameMonthEnd, "mmm yyyy" ) RETURN Result