YOY%

Hi, you must be new here. YOY% calculation can be done in many ways, and mostly dependant on how your model is structured. If you could provide more details, eg a sample of your data etc, the community may be able to help you faster.

For now, the quick and dirty way is this:

Here is a resource for quick measure
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

Hiii huzzapac 

YoY % Change =
VAR CurrentYearPrice =
CALCULATE(
SUM(PropertyTable[Current_Price]),
FILTER(PropertyTable, PropertyTable[Year] = MAX(PropertyTable[Year]))
)

VAR PreviousYearPrice =
CALCULATE(
SUM(PropertyTable[Current_Price]),
FILTER(PropertyTable, PropertyTable[Year] = MAX(PropertyTable[Year]) - 1)
)

RETURN
IF(
NOT ISBLANK(PreviousYearPrice),
DIVIDE(CurrentYearPrice - PreviousYearPrice, PreviousYearPrice, 0),
BLANK()
)



If this helps, I would appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

I want it only based on years not based on the property type column I have ploted in table