Help with Measure / Calculated Column

[Anonymous]

Hello I need help for having the following value.
Save the max value as it is growing.
Sum the the deltas till last avaialble date as it starts decreasing from local max
Any ideas?
Thank you in advance. 

Table of attributes: 

item	QNTY	Date
A	760	10/02/2022 10:19
B	329	10/02/2022 10:19
B	426	10/02/2022 10:19
B	637	10/02/2022 10:19
B	1000	10/02/2022 10:19
B	1000	10/02/2022 10:19
B	1000	10/02/2022 10:19
B	1000	10/02/2022 10:19
B	1000	10/02/2022 10:19
B	1000	09/02/2022 10:19
B	1000	09/02/2022 10:19
B	1000	10/02/2022 10:19
A	1000	10/02/2022 10:19
A	1000	10/02/2022 10:19
A	1000	10/02/2022 10:19
A	1000	10/02/2022 10:19
A	1000	10/02/2022 10:19
A	1000	08/02/2022 10:19
A	1000	08/02/2022 10:19
A	1000	10/02/2022 10:19

[Anonymous]

Hi @Anonymous ,

This appears to be a difference accumulation calculation, but how do we determine when to start the accumulation? Based on the date when the maximum value starts? Could you please provide more example data and the logic behind the calculation? It would be nice to include some examples and some screenshots to illustrate.

In addition, please review the solution in the following threads with similar requirement as you. Hope they can help you.

Calculate Differences of cumulative values by factorial group and date OR id

Dax formula calculate Difference cumulative

Best Regards

[amitchandak]

@Anonymous , You can remove timestamp and join date with date table

You can get last noncontinuous date like 

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9