Create dynamic label

[Granz03]

Use a dynamic label (YoY Sales <current year> vs. <prior year>) and display it in a KPI.

[anat]

='YoY sales'&max(year) &'.vs'&max(year) -1

[Granz03]

Hey thanks for you help still getting an error showing up 

[Rohan]

Hi @Granz03 ,

By "year", @anat  meant to use the field in your data model which denotes Year. If no such column is present then use :

year(max(Date_Field))

Regards,

Rohan.

[anat]

as suggested by @Rohan ,use your field names in the above expression