Forum Discussion
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...
This worked:
Users Last Year = CALCULATE(SUM('GA Traffic'[Users]),SAMEPERIODLASTYEAR('GA Traffic'[Date]), AllExcept('GA Traffic', 'GA Traffic'[Date]))
No, I am not using filters
SAMEPERIODLASTYEAR, Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
See the lasts words from the description. What is your filter context?
This worked:
Users Last Year = CALCULATE(SUM('GA Traffic'[Users]),SAMEPERIODLASTYEAR('GA Traffic'[Date]), AllExcept('GA Traffic', 'GA Traffic'[Date]))