topic Cumulative Progress in DAX Commands and Tips

Cumulative Progress

ajisharavind_99 — Fri, 11 Nov 2022 21:03:41 GMT

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] )

)

Re: Cumulative Progress

FreemanZ — Sat, 12 Nov 2022 01:21:34 GMT

tyr to replace ALLSELECTED with ALL:

CALCULATE (

[Plan_Progress],

FILTER (

ALL ( Month_Table ),

Month_Table[Date]

<= MAX ( Month_Table[Date] )

)

Re: Cumulative Progress

ajisharavind_99 — Sat, 12 Nov 2022 06:12:21 GMT

Thank you FreemanZ