cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Allav Frequent Visitor
Frequent Visitor

Creating a cumulative sum based on filters in the table

Hi All,

 

I am struggling to solve the below case. I want to do a cumulative sum of the "dosage" column based on the "Case ID_Milestone" key and runing based on the "date" column. instead, I am getting a sum of all the dosage of all the dates combined, not as runing total based on the date. what am I missing?

 

also, I would like to add another column of the cumulative %, would appreciate your suggestions on how to do it as wellimage.png

1 ACCEPTED SOLUTION

Accepted Solutions
Allav Frequent Visitor
Frequent Visitor

Re: Creating a cumulative sum based on filters in the table

was able to solve it! I used:

 

Cumulative Dosage =

CALCULATE

(SUM ('Daily Dosage'[Dosage]),

FILTER(ALLEXCEPT('Daily Dosage','Daily Dosage'[Case ID_Milestone]),

('Daily Dosage'[date]<=EARLIER('Daily Dosage'[date]))))

 

basically changed the MAX to EARLIER and it worked!

1 REPLY 1
Allav Frequent Visitor
Frequent Visitor

Re: Creating a cumulative sum based on filters in the table

was able to solve it! I used:

 

Cumulative Dosage =

CALCULATE

(SUM ('Daily Dosage'[Dosage]),

FILTER(ALLEXCEPT('Daily Dosage','Daily Dosage'[Case ID_Milestone]),

('Daily Dosage'[date]<=EARLIER('Daily Dosage'[date]))))

 

basically changed the MAX to EARLIER and it worked!