Forum Discussion

procyon82's avatar
procyon82
Resolver I
10 years ago
Solved

SAMEPERIODLASTYEAR()

I use   Revenue Last Year = CALCULATE(SUM('GA Ecommerce'[Revenue]),SAMEPERIODLASTYEAR('GA Ecommerce'[Date])) to create a column to have my last year's revenue in reference to what is displayed on m...
Need Help
  • procyon82's avatar
    procyon82
    10 years ago

    This worked:

     

    Users Last Year = CALCULATE(SUM('GA Traffic'[Users]),SAMEPERIODLASTYEAR('GA Traffic'[Date]), AllExcept('GA Traffic', 'GA Traffic'[Date]))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

hi all, I test this solution and worked for me:

 

workarround:

nest two functions: add date and previous month

 

Importe MismoMes AñoAnt =
CALCULATE(
SUM('MR GOPMX_ViewA'[Importe MN]), DATEADD(PREVIOUSMONTH(DateDim[FullDateAlternateKey]),-11,MONTH))