Seeking some assistance or direction to any tutorials with similar concepts.
I am trying to create an exception report. I have various tasks with a Created Date, Due Date & Complete Date.
Currently my dates filter is actively connected to the complete date and inactively connected to the Created date.
I am trying to find out which incomplete tasks have remained outstanding for 3, 5 or longer than 10 working days.
Looking through the forum these are the measures i have so far:
Total Incomplete Tasks = CALCULATE ( COUNT ( AcquistionsThreads[TaskID] ), FILTER ( AcquistionsThreads, AcquistionsThreads[TaskStatus] <> "Complete" && AcquistionsThreads[TaskStatus] <> "Aborted" ) )
Task Days Lapsed = VAR StartDate = MIN ( AcquistionsThreads[TaskCreatedDate] ) VAR DueDate = TODAY () RETURN CALCULATE ( COUNTROWS ( Dates ), FILTER ( ALL ( Dates ), Dates[Date] >= StartDate && Dates[Date] < DueDate ), FILTER ( ALL ( Dates ), Dates[IsworkingDay] = 1 ) )
Days Lapsed Incomplete Tasks = VAR taskstatus = SELECTEDVALUE ( AcquistionsThreads[TaskStatus] ) RETURN SWITCH ( TRUE (), taskstatus = "Complete", BLANK (), taskstatus = "Aborted", BLANK (), [Task Days Lapsed] )
I’m not sure how i can connect the measures to get it into a format :