Cumulative Total Without Future Days

You may apply a filter on the InvoiceDate to show data for the past records only.

Set the date range to whatever earliest launch date you have.

ajmonster,

---

 

 The 90Days table is defined as:

 

90Days =

GENERATESERIES(

-28,

DATEDIFF(MIN(Depletions[Invoice Date]), TODAY(), DAY),

1

)

 

The calculated column DateDiff is defined as:

 

 

---

I have a current measure that calculates the cumulative total over the course of a launch period (days after launch). While it calculates the total correctly, it also shows a total for days that haven't occured. 

Could you clarify the logic of the measures 90Days and DateDiff and clarify more details about the issue?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.