Forum Discussion
procyon82
Resolver I
Resolver ISAMEPERIODLASTYEAR()
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]))
Have you a filter on the two dates? Each measure uses a different column date.
procyon82Resolver I
Resolver INo, 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?
- procyon82
This worked:
Users Last Year = CALCULATE(SUM('GA Traffic'[Users]),SAMEPERIODLASTYEAR('GA Traffic'[Date]), AllExcept('GA Traffic', 'GA Traffic'[Date]))