Cumulative Progress

Question

Hi,&nbsp;&nbsp;I am looking for a solution to the calculate cumulative progress based on the last datei.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 :&nbsp;&nbsp;CALCULATE (&nbsp; &nbsp; [Plan_Progress],&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; ALLSELECTED ( Month_Table ),&nbsp; &nbsp; &nbsp; &nbsp; Month_Table[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;= MAX ( Month_Table[Date] )&nbsp; &nbsp; ))

freemanz · Accepted Answer

tyr to replace ALLSELECTED with ALL:&nbsp;CALCULATE&nbsp;(&nbsp; &nbsp;&nbsp;[Plan_Progress],&nbsp; &nbsp;&nbsp;FILTER&nbsp;(&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;ALL&nbsp;(&nbsp;Month_Table&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Month_Table[Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;=&nbsp;MAX&nbsp;(&nbsp;Month_Table[Date]&nbsp;)&nbsp; &nbsp; ))

Forum Discussion

Cumulative Progress

2 Replies

Related content

Weekly and Cumulative Progress

Measure calculation of cumulative progress %

Cumulative Total

Progressive Date Columns

Cumulative progress chart [Model attached]