Forum Discussion
Solved
Deviation & comitted calcuation
I am trying to calculate Deviation & comitted calculation Comitted graph: x-axis : number of Tasks closed on last day (11/7/23) of iteration from committed (closed state ) / (number of tasks pl...
bgashok , Please find the measures you need
Task Planned = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID])) Task Closed = Sumx(Table2, CountX(filter(Table1, Table1[Iteration] = Table2[Iteration] && not(ISBLANK(Table1[Closed Date ])) && Table1[Closed Date ] = Table2[End Date] && Table1[ID] in SUMMARIZE(filter(Table1, Table1[Iteration] = Table2[Iteration] && Table2[Start Date]= Table1[ calendar Date] && [State] <> "closed"), Table1[ID])), Table1[ID]))File attached after signature
HI bgashok,
I'd like to suggest you take a look at the following blog start date, end date part to know how to handle with this requirement:
Before You Post, Read This: start, end date
Regards,
Xiaoxin Sheng