Need help about dax to find diff

Hi  Oran1234,

I created some data:

Here are the steps you can follow：

1. Add Column – Index Column – From 1.

2. Create calculated column.

diff between above and below =
var _above=CALCULATE(SUM('Table'[production technology]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])))
var _blew=CALCULATE(SUM('Table'[production technology]),FILTER(ALL('Table'),'Table'[Index]=EARLIER('Table'[Index])-1))
return
IF(_blew=BLANK(),BLANK(),
_above-_blew)

3. Result:

If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly