Forum Discussion
I need help ! :)
Hi:) I need help !!!
Imagine the following table:
| Value | Date | Episode |
| 95 | 30/03/2021 21:48 | 24 |
| 14 | 30/03/2021 12:48 | 23 |
| 16 | 30/03/2021 09:48 | 23 |
| 20 | 30/03/2021 06:48 | 23 |
| 40 | 30/03/2021 00:48 | 23 |
| 91 | 29/03/2021 21:48 | 23 |
| 40 | 29/03/2021 18:48 | 22 |
| 50 | 29/03/2021 15:48 | 22 |
| 70 | 29/03/2021 12:48 | 22 |
| 92 | 29/03/2021 09:48 | 22 |
| 50 | 29/03/2021 06:48 | 21 |
What would be the best formula for: SUM of all difference of values between each episode changes
SUM of (episode last item 21 to first 22)=(92-50) + episode(last22-first23) = (91-40) + episode (last24-first23) =(95-14)
Thank you in advance !!
Hi, Bertille
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
all measures are in the sample pbix file.
https://www.dropbox.com/s/vwp2ofyd70zamru/bertille.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
2 Replies
- Jihwan_Kim
Super User
Hi, Bertille
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
all measures are in the sample pbix file.
https://www.dropbox.com/s/vwp2ofyd70zamru/bertille.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/Hello Jihwan_Kim
thank you very much for you help!
