Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |