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.

vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Thank you for reply,

 actually there is not balance colume i required a balance colume as a running total so that if it filter a car number automatically it should the balnce from start date to end date as shown in the example but your query will show the same for all the days