DAX

[Anonymous]

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(SalesDataDates)) -- store max Year No from sales data table

Return

Calculate(CY YTD Sales, dateTable[MonthNo]<=MM&&dateTable[YearNo]<=YY)

Somebody please help

[tamerj1]

hi @Anonymous 

It depends on the filter context but you may try

VAR YY=YEAR ( MAXX ( ALL ( SalesData ), SalesData[Dates] ) )