Forum Discussion
Solved
Dax Query Not working
CurrentMonthLastYearCount = VAR SelectedMonth = MAX(Query1[SetupDate]) VAR LastYearSameMonthStart = EOMONTH(SelectedMonth, -12) + 1 VAR LastYearSameMonthEnd = EOMONTH(SelectedMonth, -12) RETURN CALCU...
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
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