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!
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