Find the delay in course development milestone when only Planned delivery date is available

[Gouthami_22]

Hi All,

 Sample data to track the delays

Course Number	Milestone	Estimated delivery date	Actual delivery date
Course1	1a	1/1/2018	1/10/2018
	1b	1/5/2018	1/15/2018
	2a	2/8/2018	2/10/2018
	2b	2/15/2018
	3a	3/22/2018
	3b	4/1/2018
	4a	5/22/2018

This is sample data for only one course. Similarly I have multiple courses.

1. All courses should be tracked at one glance. 

In the above example 2b milestone delay also should be calculated.

Requirement:

Would like to track all the courses and each milestones delay. 

This is how they would like to see the line graph

Though the Actual date for Current milestone(2b) is not present, we should calculate the delay with todays date and project that delay in the visual. 

We tried with line chart but it's expecting a value and only course is being tracked at a time.

1.Please suggest the best visual that suits the requirement.

2. Dax to calcuate the current milestone delay with today.
3. Other milestones delay is not required which are empty for actual delivery date.

[mahoneypat]

Please check out the As Timeline visual in AppSource.  Here is what it would look like with your sample data (for the one course, with the Stacked format option turned off).  You can also add a calculated column with the delay in days to your table with the expression below, and put it in the Overlay field well of the visual to show the delay.

Delay Days = var estdate = Milestones[Estimated delivery date]

var actdate = Milestones[Actual delivery date]

return IF(ISBLANK(actdate),IF(estdate<=TODAY(), DATEDIFF(estdate, TODAY(), day)),DATEDIFF(estdate, actdate, day))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat