get the cumulative on activity and date level

[elcabansh]

greeting 

this dax works great to get the cumulative for the previous days and as per the line chart.

but in the matrix, it does not work right for the task, it didn't consider the cumulative for each task.

the power bi file 

https://drive.google.com/file/d/1fseiBx1NiTKKE8MsYLUVSMrM4CkgWzYF/view?usp=sharing

[Anonymous · Accepted solution]

@elcabansh 

I do not see any problem with @amitchandak's suggestion.

CUM PLANNED/DAY =

CALCULATE(SUMX(FILTER(ALL('PRI-TASK(baseline)'),'PRI-TASK(baseline)'[days]<=MAX('PRI-TASK(baseline)'[days])&& [TASK_NAME]=MAX([TASK_NAME])),'PRI-TASK(baseline)'[*PLANNED/DAY]))

You used [days] as the running total context, if you change the [monthyear] to [days] you will see the cumulative value but the table will be overly long to have each day displayed on the columns. So I am not sure about your needs, If that is not what you are looking for, please share your expected output. 

Paul Zheng _ Community Support Team

[elcabansh]

thanks for your reply, but unfortunately it doesn't work .

the power bi file in this link 

https://drive.google.com/file/d/1fseiBx1NiTKKE8MsYLUVSMrM4CkgWzYF/view?usp=sharing

[amitchandak]

@elcabansh , If you want cumulative at task level

add to filter

&& Task[Task_name] = Max(Task[Task_name])

Rest keep as is

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.