I need help ! :)

[Bertille]

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 !! 

[Jihwan_Kim · Accepted solution]

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/

[Bertille]

Hello @Jihwan_Kim 

thank you very much for you help!