Simple Excel Calculation to Perform in Power bi

[Anonymous]

Hi, 

I have this simple excel function and I am very new to DAX and measures and was wondering if there is a simple way to preform this task in power bi. 

My goal is for every new calcuated total the projected total value will update. 

Thanks!

[PaulDBrown]

What does your data look like?

[Anonymous]

Hi, 

In power bi I transform my 2 rows of data  to 2 columns and they are both number columns with many rows. My goal is start to with a total and subract a value form the second column then update the total and subtract the next value from the second column. 

total 200 

column = 2

new total = 198 

so on... and create a new column 

[Anonymous]

I have tried this DAX instead, however, I keep getting an error with my index column I created in queary editory. 

Improvements =

DDBB[Total Column]

    - SUMX (

        FILTER (

            DDBB,

           DDBB[Index]< EARLIER(DDBB[Index])

        ),

        DDBB[Current Improvement1]

    )

Thanks!