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!
