Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Running total Error

I am trying to put running total based on date, i am getting error for the below calculation,

#RT = CALCULATE(SUM(Day_Wise[Day Expenses]),FILTER(ALLSELECTED(Day_Wise),Day_Wise[Transactions_#R_Date]<=MAX(Day_Wise[Transactions_#R_Date])))
 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , This formula seems correct, are these Qtr, month and day are part of this date Transactions_#R_Date

    or some other date ?

    Add year and check.

    But I doubt date only

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    5 years ago

    Hi, Anonymous ,

     

    I have tried to calculate with your measure and it is correct. It returns the following results:

    If the result is your image appears, May be only uses ALLSELECTED(Day_Wise), For example:

    error total = CALCULATE(SUM(Day_Wise[Day Expenses]),ALLSELECTED(Day_Wise))

    and it will appear this image:

    If that doesn't solve your problem, can you share me with pbix file after removing sensitive data.

    Best Regards,
    Community Support Team_ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.