Forum Discussion

NaCl-y's avatar
NaCl-y
Frequent Visitor
8 years ago

Need help calculating recursive Past Overdues

I'm trying to build a Line and Chart column chart. In the first bar, i would like to put in the Plan Finish and have another bar on top that shows the Past Overdue (overdue from previous month). In the line, i would put the Actual Finish. 

 

I have already calculated the number of Plan Finish and Actual Finish seen below. I've made a Date Table and connect it to the Plan Finish and Actual Finish column. And i counted the dates that are in the specified month.

Nb of Plan = CALCULATE(Count(EngineFeedback[PLAN FINISH])) 

Nb of Actual = CALCULATE(Count(EngineFeedback[PLAN FINISH]),USERELATIONSHIP('Date Table'[Date],EngineFeedback[ACTL.FINISH]))

I'm having trouble calculating and expressing the Past Overdue on DAX. It works this way, (Plan Finish + Past Overdue) - Actual Finish = Overdue. And this Overdue will become the Past Overdue for the next month of production. It is recursive and i don't know how to implement it.

 

Thanks in Advance!