Forum Discussion
Cumulative Value
Hi,
Try this calculated column formulas
Cumulative count = CALCULATE(SUM(Data[Count]),FILTER(Data,Data[Function]=EARLIER(Data[Function])&&Data[Date]<=EARLIER(Data[Date])))
Cumulative count - Done = if(Data[Status]="Not Done",BLANK(),CALCULATE(SUM(Data[Count]),FILTER(Data,Data[Function]=EARLIER(Data[Function])&&Data[Status]="Done"&&Data[Date]<=EARLIER(Data[Date]))))
Hope this helps.
The cumulative Done worked , but the Cumulative all is coming up with weird number not sure if they're true.
function Date status Count Cumulative all Cumulative done Date A 4/1/2021 done 3 3 3 2021-04-01 0:00 A 5/1/2021 done 2 5 5 2021-05-01 0:00 A 6/1/2021 done 5 39 10 2021-06-01 0:00 A 6/1/2021 not done 1 46 17 2021-07-01 0:00 A 6/1/2021 not done 2 28 22 2021-08-01 0:00 A 7/1/2021 done 7 64 25 2021-09-01 0:00 A 7/1/2021 not done 3 126 29 2021-10-01 0:00 A 8/1/2021 done 5 144 33 2021-11-01 0:00 A 9/1/2021 not done 1 106 35 2021-12-01 0:00 A 9/1/2021 done 3 57 2022-01-01 0:00 A 10/1/2021 not done 5 124 2022-02-01 0:00 A 10/1/2021 done 4 73 2022-03-01 0:00 A 10/1/2021 not done 1 74 2022-04-01 0:00 A 11/1/2021 not done 1 A 11/1/2021 done 4 A 11/1/2021 not done 1 A 12/1/2021 not done 3 A 12/1/2021 done 2 A 1/1/2022 not done 4 A 2/1/2022 not done 4 A 2/1/2022 not done 1 A 3/1/2022 not done 11 A 4/1/2022 not done 1 Hi,
As you can see in my screenshot, my formulas are working fine. I am not sure of what you are doing. Share the link from where i can download your PBI file with the formula already written there.
Hi tony_tohme ,
I suspect the error is because Ashish_Mathur 's formula is "Not Done", but your data is "not done", you should modify this in your formula.
Cumulative count - Done = if(Data[Status]="Not Done",BLANK(),CALCULATE(SUM(Data[Count]),FILTER(Data,Data[Function]=EARLIER(Data[Function])&&Data[Status]="Done"&&Data[Date]<=EARLIER(Data[Date]))))
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
