Forum Discussion
Solved
Calculate slopes between two points
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.
Here's my version (as a measure - could be a column too, I guess)
1 Reply
Here's my version (as a measure - could be a column too, I guess)