DAX calculation for the year before last

[Anonymous]

Hello,

I would like to create an equivalent calculation to DATESYTD and SAMEPERIODLASTYEAR, but for the year before last.

[FreemanZ · Accepted solution]

hi @Anonymous 

try like:

measure =

CALCULATE(

   ,

   DATEADD(DateTable[Date], -2, YEAR)

)

[griveraII]

Hi @FreemanZ I am looking for a DAX that will only pull the last year YYYY format and not MM/DD/YYYY.