Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
4 years ago

SALES_ after replace as SALES_M , it give error msg

Hi All   Below expression working for last 3 year :-   SALES_YOY = var _max = format(today(),"MMDD") return calculate(Sum('SALES'[SALES_]),DATESYTD('DATE'[Date]),format('DATE'[Date],"MMDD")<...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

admin11 , SalesM is measure

 

Try

 

SALES_YOY =
var _max = format(today(),"MMDD")
return
calculate(('SALES'[SALES_M]),DATESYTD('DATE'[Date]),format('DATE'[Date],"MMDD")<=_max)
 
or
 
SALES_YOY =
var _max = format(today(),"MMDD")
return
calculate(Sumx('SALES',[SALES_M]),DATESYTD('DATE'[Date]),format('DATE'[Date],"MMDD")<=_max)