Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

LY YTD Calculation

Hi,   I need assistance with creating a DAX formula for LY YTD values. FYI - I have a period slicer in my model (2 slicers, YEAR and QUARTER).   The problem is, the values in my model have...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous ,

with date calendar one of these should work

Year behind Sales = CALCULATE([RevA ],dateadd('Date'[Date],-1,Year))
Last YTD Sales = CALCULATE([RevA],DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))