Sum previews rows in DAX

Question

Hello,&nbsp;this query&nbsp;EVALUATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECTCOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUMMARIZECOLUMNS(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Times[TimeID]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, Items[Factor]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, OperationOrders[Quantity]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, FILTER(Stations, Stations[BillOfResourcesName] = "Bor1")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, FILTER(OperationOrderRows, OperationOrderRows[OperationOrderCode] = "OO-1")&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;, FILTER(NATURALINNERJOIN(Machines,Stations), OR (AND (Machines[IsInBound]=True, Stations[Type]=0), Stations[Type]=1))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,"Qty", SUM(Productions201801[Pieces])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,"TimeID", [TimeID]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,"Factor" , [Factor]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,"QtyPerFactor", [Quantity]-[Qty]*[Factor]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)order by [TimeID]&nbsp;return this result&nbsp;TimeID | Factor | QueryPerFactor0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,36560&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,365150&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,365210&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,365300&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,365&nbsp;I need to obtain in the QtyPerFactor column the value of the QtyPerFactor&nbsp;preview rows minus the Factor column value&nbsp;Than i need this result&nbsp;TimeID | Factor | QueryPerFactor0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 229,36560&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 228,730150&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp;&nbsp;228,095210&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp; 227,460300&nbsp; &nbsp; &nbsp; |&nbsp; &nbsp;0,635 |&nbsp;&nbsp;226,825ecc...&nbsp;Can anyone help me?Thanks so much!&nbsp;

v-chuncz-msft · Accepted Answer

AlexEnergee3,
&nbsp;
You may add a calculated column as follows.
Column =
MAXX (
    TOPN ( 1, Table1, Table1[TimeID], ASC ),
    Table1[QtyPerFactor] + Table1[Factor]
)
    - SUMX (
        FILTER ( Table1, Table1[TimeID] &lt;= EARLIER ( Table1[TimeID] ) ),
        Table1[Factor]
    )

Forum Discussion

Sum previews rows in DAX

1 Reply

Related content

SUM rows

SUM row by row

How to Sum Row Count and show total sum value in every row

Row Count Sum

Sum of rows