Forum Discussion
Euro0681
Helper II
Helper IIPrevious Year Sum
again another simple question but maybe im over thinking it. I'm wanting to calculate the SUM('Table'[Sales]) (At a given time) for the previous year at a given quarter, I guess my confusion is wh...
FreemanZ
Super User
Super UserTime intelligence helps shifting calculation period. With this code, to show the Q4 of the previous year, you need somewhere in your visual with the context of Q4 of this year.
= Calculate(
Sum('Table'[Sales]),
DateAdd('Table'[Date], -1, YEAR)
)