Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

running total with filter date

Can any one help with dax for filter date and car number should get running total of the person from stating  example table Name Car  Amount Type of debit Date Net Debit Credit Balance ...
  • vivek31's avatar
    vivek31
    2 years ago

    Hi, Anonymous 

     

    try below code for measure

    running total = CALCULATE(SUM('Table (4)'[Balance]),
                               FILTER(
                                ALLSELECTED('Table (4)'),
                                'Table (4)'[Date]<=MAX('Table (4)'[Date])))

     

     

    All date are same that the reason total balance are same in all row

     


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Anonymous 

try below code for new column

Column = 
SUMX(
    FILTER(
        ALL('Table (2)'),
         'Table (2)'[Name]=EARLIER('Table (2)'[Name]) && 
         'Table (2)'[Car ]=EARLIER('Table (2)'[Car ]) && 
         'Table (2)'[Date]<=EARLIER('Table (2)'[Date])
    ),
    'Table (2)'[Balance]
)

 

just adjust table name and column name