Getting milestone dates

[ye348]

Hi all im trying to do something in powerbi that will allow me to highlight specific dates as my milestone dates. at the moment i have two different columns that calculate percent complete, one is the actual and one is the planned or projected rate. the projected rate just uses the start and end dates as a range and divides the total number of elements im trying to compelte by the duration of days in the start/end dates for each company. What I would like to be able to do is return a table that calls or returns a date for when my expected or planned rate should be at 25, 50, 75 & 100 percent complete. just as a disclaimer the dates on the milestone table are just arbitrary

Input data
company	Percent complete (actual)	Percent complete (planned)	start date	end date
A	20	43	10/7/2024	12/3/2024
B	34	92	9/8/2024	12/4/2024
C	62	10	9/9/2024	12/5/2024
D	95	53	9/10/2024	12/6/2024
Expected result
company	Milestone Dates at 25%	Milestone Dates at 50%	Milestone Dates at 75%	Milestone Dates at 100%
A	11/5/2024	11/13/2024	11/23/2024	12/3/2024
B	11/6/2024	11/14/2024	11/24/2024	12/4/2024
C	11/7/2024	11/15/2024	11/25/2024	12/5/2024
D	11/8/2024	11/16/2024	11/26/2024	12/6/2024

[MNedix]

Heya,

I don't really understand the logic you're trying to implement. I assume the dates are US format (Month/Day/Year) - the end date should be after start date. A simple calculation would return 57 days between start and end for Company A. If you calculate the milestone date only based on this variable, 25% would be ~14 days which added to the start date of 7th of October would mean 21st of October not 5th of November.

Unless I misunderstand the whole problem. How did you get to the 5th of November?

Cheers

[ye348]

my apologies, i really just filled in arbitrary dates for the milestone dates, but the logic is it would return a date for me thats within that start/end range that would correspond to when the planned rate should be at 25, 50, 75%, etc... complete

[MNedix · Accepted solution]

Please check the attached, it may address your problem.

If it solved your problem then please mark it as the solution so others can see it.

Best,

[ye348]

yes this was exactly what i was looking for, thank you.