Forum Discussion
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
| 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!
Hi,
Please find attached my PBi file.
Hope this helps.
1 Reply
- Ashish_MathurSuper User