Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new user in powerbi and need help. Table named techniquee and has 3 columns in power bi. First column is Integer. How can I calculate the difference of each technique compared to the previous year? Result should be in Difference columns name.
Year | Technique | Value | Difference(result column) |
2000 | Agile | 0 | 0 |
2000 | Devops | 2 | 0 |
2001 | Agile | 10 | 10 |
2001 | Devops | 15 | 13 |
2002 | Agile | 50 | 40 |
2002 | Devops | 80 | 65 |
Solved! Go to Solution.
try like:
DifferenceColumn =
VAR _valuepre =
MAXX(
FILTER(
Technique,
Technique[Technique]=EARLIER(Technique[Technique])&&Technique[Year]<EARLIER(Technique[Year])
),
Technique[Value]
)
RETURN
[Value] - _valuepre
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |