cumulative sum by specific date

[husseinseraj]

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.

[Anonymous]

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.