Calculation

[Aditya-2231]

Hi I'm pasting an Excel. I want to implement same in power bi. Value is measure that is already present. And need column is ask.

[Aditya-2231]

Hi ss is already pasted. Same data is pulling in power bi. Thanks

[ryan_mayu]

@Aditya-2231 

could you pls provide some raw data?

[Aditya-2231]

Hi ss is already pasted. Same data is pulling in power bi. Thanks

[ryan_mayu]

@Aditya-2231 

pls try this

Column = 
VAR _start=maxx(FILTER('Table','Table'[month]=min('Table'[month])),'Table'[value])
VAR _start2=MINX(FILTER('Table','Table'[month]>min('Table'[month])),'Table'[month])
RETURN _start-sumx(FILTER('Table','Table'[month]>=_start2&&'Table'[month]<=EARLIER('Table'[month])),'Table'[value])

[Aditya-2231]

I'm getting circular depedancy error.

[ryan_mayu]

@Aditya-2231 

you can try this

measure = 
var _min=CALCULATE(min('Table'[month]),ALL('Table'))
VAR _start=maxx(FILTER(all('Table'),'Table'[month]=_min),'Table'[value])
RETURN _start-sumx(FILTER(all('Table'),'Table'[month]>_min&&'Table'[month]<=max('Table'[month])),'Table'[value])

pls see the attachment below