Forum Discussion

ChihiroWa's avatar
ChihiroWa
Frequent Visitor
3 years ago
Solved

Calculate YoY

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

NameSub nameCYVolumeCY(yyyy)
AxxxCY20221002022
AyyyCY20232002023
BxxxCY20003002000
BzzzCY20014002001

 

 

 

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!