topic Re: I need help ! :) in DAX Commands and Tips

I need help ! :)

Bertille — Tue, 13 Apr 2021 16:21:19 GMT

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

Re: I need help ! :)

Jihwan_Kim — Tue, 13 Apr 2021 17:11:48 GMT

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/

Re: I need help ! :)

Bertille — Wed, 14 Apr 2021 14:42:05 GMT

Hello Jihwan_Kim

thank you very much for you help!