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.

      • procyon82's avatar
        procyon82
        Resolver I
        10 years ago

        No, I am not using filters