Forum Discussion

zflory's avatar
zflory
Icon for Helper I rankHelper I
8 years ago

Year over Year Comparison

Hello,   I am currently have a matrix that displays Volume and Plant Margin by Volume. How would I be able to show a year over year comparison for these 2 categories? I have all of the data for 201...
Need Help
nickchobotar's avatar
nickchobotar
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

zflory

 

I like writing my YOY metrics all in one measure with variables.

 

YoY Volume =
VAR Volume = SUM(Table1[Volume])
VAR VolumeLastYear = CALCULATE(Volume, DATEADD(Date[Date], -1, YEAR))
RETURN
Volume - VolumeLastYear 


Same for the % ratio

YoY Volume% =
VAR Volume = SUM(Table1[Volume])
VAR VolumeLastYear = CALCULATE(Volume, DATEADD(Date[Date], -1, YEAR))
YOY_Volume = Volume - VolumeLastYear
RETURN
DIVIDE(YOY_Volume, VolumeLastYear)

 

- N

 

zflory's avatar
zflory
Icon for Helper I rankHelper I
8 years ago

thank you for the help!