Calculate YoY

[ChihiroWa]

Hi! I hope my words make sense although I am not IT person and my first language is not English.

I am trying to create a measure to calculate YoY, but I goes wrong.

What I want to do is:When a slicer is chosen 'CY2023', a card shows YoY % of production volume(CY2022 vs CY2023). This slicer has multiple choises through CY2000 to CY 2023, so YOY must be change by a chosen CY.

TableA is like this; production volume through 2000 to 2023

Name	Sub name	CY	Volume	CY(yyyy)
A	xxx	CY2022	100	2022
A	yyy	CY2023	200	2023
B	xxx	CY2000	300	2000
B	zzz	CY2001	400	2001

What I tried:

  *Sorry for including Japanese language

1. Create a measure to calculate prior year  →Succeeded

2.Create a measure to calculate volume of prior year  → Go wrong

   Volume(PriorYear) = CALCULATE(SUM('TableA'[Volume]),ALL(('TableA'),'TableA'[CY(yyyy)]='Measure'[PriorYear]

Error: 

Function 'placeholder' is used in a true/false expression used as a filter expression for a table. This is not allowed.

Sorry for my bad English.

I hope someone heplp me!

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached my PBi file.

Hope this helps.