New YoY% set as target as column

[Anonymous]

Hi 

I appreciate if you can please help me. I have a table like attached, where in column Date I have 2 Dates one in 2022 and one in 2021. I can use YoY% by quick measure in Power Point to get the value of YoY% (e.g. 4% for Type A and 32% for Type B). But I'd like to set the target as if YoY% is 7% and 40% respectively. I'd need to check the performance of e.g. cities against the target. Can you please help me how would can I do that? Thank you. 

Kind Regards,

Date	Type	Sales	city	Colour
23/06/2022	A	60738	Auckland	Blue
23/06/2022	A	23910	Auckland	Red
23/06/2022	A	188628	Auckland	Blue
23/06/2022	A	40326	Auckland	Orange
23/06/2022	A	101994	Auckland	Blue
23/06/2022	A	70746	Auckland	Red
23/06/2022	A	6997.92	Auckland	Blue
23/06/2022	A	140699.44	Auckland	Orange
23/06/2022	A	20726.88	Auckland	Blue
23/06/2022	A	49876.8	Auckland	Red
23/06/2022	B	23837.28	Auckland	Blue
23/06/2022	B	185514	Auckland	Orange
23/06/2022	A	100395.6	Auckland	Blue
23/06/2022	A	39973.36	Auckland	Red
23/06/2022	A	70584	Auckland	Blue
23/06/2022	A	20785.2	Auckland	Orange
23/06/2022	A	114810	Auckland	Blue
23/06/2022	A	19206	Auckland	Orange
23/06/2022	A	76133.04	Auckland	Blue
22/06/2021	A	180522.6	Auckland	Red
22/06/2021	A	13727.4	Auckland	Blue
22/06/2021	B	139073.28	Auckland	Orange
22/06/2021	B	79162.44	Auckland	Blue
22/06/2021	B	139073.28	Auckland	Red
22/06/2021	A	79162.44	Auckland	Blue

[FreemanZ · Accepted solution]

hi @Anonymous 

not sure if i fully get you, you may try to create a measure with this:

2022YoY% = 
VAR _2022 =
CALCULATE(
    SUM(TableName[Sales]),
    YEAR(TableName[Date])=2022
)
VAR _2021 =
CALCULATE(
    SUM(TableName[Sales]),
    YEAR(TableName[Date])=2021
)
RETURN
FORMAT(DIVIDE(_2022-_2021, _2022), "0.0%")

i tried and it worked like this: