Add same column rows with same column next row

Hi Sandeep13 ,
You need to create an Index column in your table first and then add a calculated column with following DAX formula:

Total (column) =
var previndex = CALCULATE(MAX(Sheet1[S.no]) - 1)
var prevvalue = CALCULATE (SUM (Sheet1[ColumnA]),FILTER (Sheet1,Sheet1[S.no] = EARLIER (Sheet1[S.no]) - 1))

Return IF(previndex > 0, CALCULATE(SUM(Sheet1[ColumnA]) + prevvalue), BLANK())

Format the above column as percentage.

This will give you the desired result(below screenshot):

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Hey 

Thank you for your response. But I am getting data like this when i  apply your logic in my data.

kIndly check

Hey Thank You its working in my dummy data but when i am implementing in my actual data its give me wrong output.

I have 1M Plus data