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]))

nikil's avatar
nikil
Resolver I
10 years ago

Formula looks right, are you sure there is data for multiple years ?

procyon82's avatar
procyon82
Resolver I
10 years ago

Yes, there definitely is data for last year. If I only use:

 

SAMEPERIODLASTYEAR('GA Traffic'[Date]), it shows me the date for last year. I'm clueless.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Have you a filter on the two dates? Each measure uses a different column date.