Create a Year on year sales KPI

[Granz03]

Hi haveing some issues createing this with in QS 

In the KPI, define a new master measure YoY Sales with the calculation of:

([Sales CY] / [Sales PY]) -1.

Where the Sales CY is the existing master measure and the Sales PY can be defined as follows:

Sum({$<Year={$(=Max(Year)-1)} , YearMonth= >} LineSalesAmount).

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

[MatheusC]

@Granz03 

Try removing ignore selection  YearMonth=

Sum({$<Year={$(=Max(Year)-1)}>} LineSalesAmount)

Regarts,
Matheus

[anat · Accepted solution]

Previous year:

Sum({<[OrderDate.autoCalendar.Year] = {"$(=Max(Year(OrderDate)) - 1)"}>} Sales)

Current year:

Sum({<[OrderDate.autoCalendar.Year] = {"$(=Max(Year(OrderDate)))"}>} Sales)

It will be based on your selection to get what is the lastest(max) possible year, and minor 1 to get its previous year.