Forum Discussion
YOY%
Hii huzzapac
YoY % Current Price =
VAR CurrentYearPrice = SUM('Property Table'[Current_Price])
VAR PreviousYearPrice =
CALCULATE(
SUM('Property Table'[Current_Price]),
SAMEPERIODLASTYEAR('Transactional Table'[Transaction_Date])
)
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!
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