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 my graph. That works beautifully!
I also added
Users Last Year = CALCULATE(SUM('GA Traffic'[Pageviews]),SAMEPERIODLASTYEAR('GA Traffic'[Date]))
and it doesn't work. It doesn't give an error, but simply stays blank.
Users Last Year = CALCULATE(SUM('GA Traffic'[Pageviews])
each work separately though. Does anybody know what's wrong?
Solved! Go to Solution.
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?
Dear friends, unfortunately this function has no solution if there is an error. It is the worst function of Power BI, because it is necessary but only works in an unknown condition and does not work in others. It's a pity that this happens in an excellent solution like Power BI. There will be no solution. If it works, use it if you do not use any other function. That's the truth.
hi all, I test this solution and worked for me:
nest two functions: add date and previous month
Importe MismoMes AñoAnt =
SUM('MR GOPMX_ViewA'[Importe MN]), DATEADD(PREVIOUSMONTH(DateDim[FullDateAlternateKey]),-11,MONTH))