Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am a beginner to DAX and I am trying to calculate the slopes for each two points of a curve :
(Index = order of X for each User)
Users | Index | X | Y | SLOPE (calculated) |
A | 1 | 0 | 4 | |
A | 2 | 0,5 | 23 | 38 |
A | 3 | 1 | 40 | 34 |
A | 4 | 1,5 | 39 | -2 |
A | 5 | 2 | 22 | -34 |
B | 1 | 0 | 9 | |
B | 2 | 0,5 | 26 | 34 |
B | 3 | 1 | 54 | 56 |
B | 4 | 1,5 | 42 | -24 |
B | 5 | 2 | 22 | -40 |
C | 1 | 0 | 13 | |
C | 2 | 0,5 | 113 | 200 |
C | 3 | 1 | 163 | 100 |
C | 4 | 1,5 | 75 | -176 |
C | 5 | 2 | 28 | -94 |
Can you help me pls ?
Best Regards.
Solved! Go to Solution.
Here's my version (as a measure - could be a column too, I guess)
User | Count |
---|---|
82 | |
79 | |
63 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |