Forum Discussion

husseinseraj's avatar
husseinseraj
New Member
2 years ago

cumulative sum by specific date

hi 

i need some help, how can i calclaute cumulative sum by specific date in table date range

 

example(i want to calculate cumulative profit up to cut of date(20-Jan-23) but my date table range up to may-25.

 

Thank you in advance.

Need Help
Show and Tell

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi husseinseraj 

     

    For your question, here is the method I provided:

     

    Here's some dummy data

     

    "Table"

     

    Create a measure to calculate cumulative profit up to cut of date (1/20/2023).

    Total_Profit = 
    CALCULATE(
        SUM('Table'[Profit]),
        FILTER(
            ALL('Table'[Date]),
            'Table'[Date] <= DATE(2023, 1, 20)
        )
    )

     

    Here is the result.

    Regards,

    Nono Chen

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