Forum Discussion

Raviteja495's avatar
Raviteja495
Frequent Visitor
2 years ago

Running total for transaction amount

I am calculating running total for the transaction amount based on person id matches.I am getting the results but if mutliple transactions having in single date means it is showing the results by calculating all that day transactions.can you please help me here

 

 

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

    I hope the below can provide some ideas on how to create a solution for your semantic model.

     

     

     

    transaction amount: = 
SUM( 'Transaction'[Amount] )

     

    WINDOW function (DAX) - DAX | Microsoft Learn

     

    Transaction cumulate: = 
CALCULATE (
    SUM ( 'Transaction'[Amount] ),
    WINDOW (
        1,
        ABS,
        0,
        REL,
        SUMMARIZE (
            ALL ( 'Transaction' ),
            'ID'[ID],
            'Calendar'[Date],
            'Transaction'[Transaction Number]
        ),
        ORDERBY ( 'Calendar'[Date], ASC, 'Transaction'[Transaction Number], ASC ),
        ,
        PARTITIONBY ( 'ID'[ID] )
    )
)