Forum Discussion

AlexEnergee3's avatar
AlexEnergee3
New Member
8 years ago
Solved

Sum previews rows in DAX

Hello,   this query   EVALUATE         SELECTCOLUMNS(         SUMMARIZECOLUMNS(                     Times[TimeID]                     , Items[Factor]                     , OperationOrders[Qu...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    AlexEnergee3,

     

    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] <= EARLIER ( Table1[TimeID] ) ),
        Table1[Factor]
    )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

AlexEnergee3,

 

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] <= EARLIER ( Table1[TimeID] ) ),
        Table1[Factor]
    )