% change calculation in power bi dax

[paw1]

Hi,

Can you please help me to calcualte % change from below data.

In each company the max date is different. 

for abc company  % change should be calcualted as = (09/30/2022 amount - 09/30/2021 amount)/09/30/2021 amount

for fgh company % change should be calcualted as = (12/31/2022 amount - 12/31/2021 amount)/12/31/2021 amount

Company	Date	Amount
abc	06/30/2021	472000
abc	09/30/2021	481100
abc	06/30/2022	514762
abc	09/30/2022	523000
fgh	06/30/2021	684028.7
fgh	09/30/2021	730662.7
fgh	12/31/2021	880901.7
fgh	06/30/2022	940806
fgh	09/30/2022	950946.5
fgh	12/31/2022	974673

@v-xinruzhu-msft 

[FreemanZ · Accepted solution]

hi @paw1 

YoY％ =

VAR _maxdate = MAX(TableName[Date])

VAR _value1 =

MAXX(

    FILTER(

        TableName, 

        TableName[Date]=_maxdate

    ),

   TableName[Amount]

)

VAR _value2 =

MAXX(

    FILTER(

        TableName, 

        TableName[Date]=EDATE(_maxdate, -12

    ),

   TableName[Amount]

)

RETURN

DIVIDE( _value1- _value2, _value2)