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

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.

  • procyon82's avatar
    procyon82
    Resolver I
    10 years ago

    No, I am not using filters

      • procyon82's avatar
        procyon82
        Resolver I
        10 years ago

        This worked:

         

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