Add Column to calculate running profit for each row from profit column

[Sadia-A]

Hi

I am in learning stage of Power BI. I came across a problem. I have a table with 2 column namely: Entry_date and profit. I want to add a Cumm Profit2 column which can calculate running total profit for each row except for the 1st row as it will remain the same. If you refer to the picture the Cumm Profit2 is not matching Cumm Profit. Kindly point out the Mistake.

[yasharma221195 · Accepted solution]

Hello,

Make sure you first understand the concept of row and filter context first,

Here replace sales column to "Profit" column, sheet1 with your table name and date with "Entry date"

Cumulative Sum  =

SUMX(

    FILTER(

        ALL(Sheet1),

        Sheet1[Date] <= EARLIER(Sheet1[Date])

    ),

    Sheet1[Sales]

)

Logic - I want to have filtered table in such a way that it will give rows older dates than the selected date row  and do the sum for that filtered table.

[Sadia-A]

Thank you for help

[Rupak_bi]

try to modify the formula with below

1.     filter(all(table)
2.      "MIN" to be replaced to "Max".