Forum Discussion

frandb's avatar
frandb
New Member
8 years ago

Subtract rows from a cumulative column value

Hi !

 

I'm having an issue calculating the difference between the value of two succesives rows as shown in the image. For example I want to substract the values of the column "Cons 1 kWh" for every row at every consecutive time.

I´ve tried several ways that I´ve found in the forum but none of them solved my problem successfuly. As an example I´ve tried to create an index column to use as a guide in de DAX code but the data base is always refreshing so afeter a few minutes the index column isn´t correct any more.

 

Could you help me please?

 

Thanks !

 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    frandb

     

    Try this column

     

    Column =
VAR RowWithPreviousTime =
    TOPN (
        1,
        FILTER ( Table1, Table1[DATETIMEPLC] < EARLIER ( Table1[DATETIMEPLC] ) ),
        [DATETIMEPLC], DESC
    )
RETURN
    Table1[Cons 1 kWh] - MINX ( RowWithPreviousTime, [Cons 1 kWh] )
      • frandb's avatar
        frandb
        New Member
        8 years ago

        Thanks !

        But running the answer you told me this message apears: "There's not enough memory to complete this operation. Please try again later when there may be more memory available."

         

        I think this problem is due to the excesive amount of data I have to process (1.700.000 rows).

        Do you have an other idea?