Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Simple Excel Calculation to Perform in Power bi

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!

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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!