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
10 years ago

Have you a table date? or have you, at least, one record for any possible date in the two years? If not, the Intelligence functions can't work as expected.