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!
I want it only based on years not based on the property type column I have ploted in table
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!