Cumulative Progress

[ajisharavind_99]

Hi,  

I am looking for a solution to the calculate cumulative progress based on the last date
i.e., I have already calculated the cumulative progress, but when I apply the date filter, it is calculating the selected month's first data to the end date, When I applied the filter, I required that the start date be the first date on my calendar and the end date be the filter's last date, then calculate cumulative progress.

Cumulative Plan Dax :  

CALCULATE (

    [Plan_Progress],

    FILTER (

        ALLSELECTED ( Month_Table ),

        Month_Table[Date]

            <= MAX ( Month_Table[Date] )

    )

)

[ajisharavind_99]

Thank you @FreemanZ 

[FreemanZ · Accepted solution]

tyr to replace ALLSELECTED with ALL:

CALCULATE (

    [Plan_Progress],

    FILTER (

        ALL ( Month_Table ),

        Month_Table[Date]

            <= MAX ( Month_Table[Date] )

    )

)