Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Return

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

 

Somebody please help

 

Calculate function

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    hi Anonymous 

    It depends on the filter context but you may try

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