Forum Discussion
DAX
l am trying to use below VAR value in the Calculate function but not working LY YTD Sales = VAR MM=month(Max(SalesDataDates)) -- store max date from sales data table VAR YY=Year(Max(SalesDataDat...
hi Anonymous
It depends on the filter context but you may try
VAR YY=YEAR ( MAXX ( ALL ( SalesData ), SalesData[Dates] ) )