YOY%

[huzzapac]

Hii Everyone!

I need to know what will be the YOY% for the price I have for the table properties with column name Current price. Please Provide me dax for that.

Thank you in Advance!

[huzzapac]

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

[Khushidesai0109 · Accepted solution]

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!

[Khushidesai0109]

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!

[huzzapac]

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

[Tutu_in_YYC]

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