Running total for transaction amount

[Raviteja495]

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

 

 

[Jihwan_Kim]

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] )
    )
)