Forum Discussion

gomezc73's avatar
gomezc73
Icon for Helper V rankHelper V
1 year ago
Solved

Issue with accumulated amounts

Hi Expert,   I need help with the following problem, any idea on how to solve it would be appreciated. I have a table that has an amount per day, so I made a calculation to generate an accumulated...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi gomezc73 ,
    Thanks for rajendraongole1 reply.
    You can create a calculate column

     

    Daily Accumulated  = 
VAR _currentDate = 'Table'[DATE]
RETURN
CALCULATE(
    SUM('Table'[AMOUNT]),
    FILTER(
        'Table',
        'Table'[DATE] <= _currentDate
    )
)

     

    Then create a line chart

     

    Best regards,
    Albert He

    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
1 year ago

Hi gomezc73 ,
Thanks for rajendraongole1 reply.
You can create a calculate column

 

Daily Accumulated  = 
VAR _currentDate = 'Table'[DATE]
RETURN
CALCULATE(
    SUM('Table'[AMOUNT]),
    FILTER(
        'Table',
        'Table'[DATE] <= _currentDate
    )
)

 

Then create a line chart

 

Best regards,
Albert He

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

  • gomezc73's avatar
    gomezc73
    Icon for Helper V rankHelper V
    1 year ago

    It works!!. thank you very Much!!