topic Re: Measure current year (context) minus last year KPI in DAX Commands and Tips

Measure current year (context) minus last year KPI

Wattar — Wed, 13 May 2020 14:04:50 GMT

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

Re: Measure current year (context) minus last year KPI

vivran22 — Thu, 14 May 2020 01:41:39 GMT

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

Re: Measure current year (context) minus last year KPI

Wattar — Thu, 14 May 2020 12:31:43 GMT

It works just fine. Thank you vivran22