DAX

Anonymous — Fri, 19 May 2023 18:21:20 GMT

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

Re: DAX

tamerj1 — Fri, 19 May 2023 18:59:36 GMT

hi Anonymous

It depends on the filter context but you may try

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