Measure current year (context) minus last year KPI

[Wattar]

Hello,

I have a years dimension table and I want to calculate a KPI wich is the difference between the value of an another KPI value in a year minus its value the year before:

KPI2 = KPI1(YearN) - KPI(YearN-1)

Any help how to do it?

Thank you

[vivran22 · Accepted solution]

Hello @Wattar ,

You may use Time Intelligence DAX for this: PARALLELPERIOD or DATEADD

KPI 2 = 
VAR KPI1 = [measure]

VAR KPI1PrevYear = 
  CALCULATE([measure], PARALLELPERIOD([date],-1,"Year"))

VAR Diff = KPI1 - KPI1PrevYear

RETURN

Diff

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

[Wattar]

It works just fine. Thank you @vivran22