Develop a planned progress line for use with planned vs actual

[texasagtom]

I am relatively new to Power BI and have an issue I cannot seem to resolve with similar posts. I am running a project where the tasks belong to phases that have start and end dates.  I need to develop a planned progress line that is filterable by phase so that evaluation of planned vs actual can be determined.  The order of completion of the tasks within the phase is not important - hence no 'planned' dates are assign - only to the phase they belong to.

Task	Phase	Start	End
a	1	2/1/2019	10/15/2019
b	3	5/1/2019	6/1/2020
c	2	2/1/2019	12/20/2019
d	1	2/1/2019	10/15/2019
e	2	2/1/2019	12/20/2019
f	2	2/1/2019	12/20/2019
g	1	2/1/2019	10/15/2019
h	3	5/1/2019	6/1/2020
i	3	5/1/2019	6/1/2020
j	3	5/1/2019	6/1/2020
k	1	2/1/2019	10/15/2019
l	1	2/1/2019	10/15/2019
m	2	2/1/2019	12/20/2019
n	3	5/1/2019	6/1/2020
o	1	2/1/2019	10/15/2019
p	1	2/1/2019	10/15/2019
q	2	2/1/2019	12/20/2019
r	2	2/1/2019	12/20/2019
s	1	2/1/2019	10/15/2019
t	2	2/1/2019	12/20/2019
u	2	2/1/2019	12/20/2019
v	2	2/1/2019	12/20/2019
w	2	2/1/2019	12/20/2019
x	1	2/1/2019	10/15/2019
y	1	2/1/2019	10/15/2019
z	2	2/1/2019	12/20/2019

Thanks in advance for any guidance!

[v-yiruan-msft]

Hi @texasagtom,

Sorry that I'm not clear about your requirement... Could you please provide your desired result in the form of screenshot or table? Thank you.

Best Regards

Rena

[Greg_Deckler]

@texasagtom Not exactly sure what you want as output. This may help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

If not, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[texasagtom]

@Greg_Deckler  @v-yiruan-msft  = Thank you so much for the interest/reply and apologies for being too vague. I will try again.  My main table has several tasks that belong to one of 24 phases.  Each phase has start and end dates, but the individual tasks, however, are not assigned individual planned completion dates - merely dates associated with the phase they are a part of.  I need to develop (either by calculated column or by measure) a way to determine the planned progress (displayed as a line graph) that pays attention to the start and end dates assigned to each task and that supports the cumulative nature of phase overlap so that I can graph planned progress, actual progress and eventually recovery forecasted line as a function of actual progress. This also should be filterable so that I can evaluate planned vs actual for each individual phase.  Here's a snapshot of data, current graph and desired end state graph:
Current report showing actual progressDesired End State

Determining how to model the 'planned line' without actual task planned completion dates is my biggest hurdle.  Actual completion dates are added as tasks are completed and once I figure out the planned, the revised estimate is an iteration of the planned - just from a different starting point. Thanks again for any thoughts or ideas.

Very Respectfully,

Tom

[scpono86]

Hey OP, did you find a solution to this? I'm trying to work it out myself?

[KM1995]

Did you find a solution for this? I have the same problem 

[Greg_Deckler]

Hmm, @texasagtom I have a whole chapter of my book dedicaed to project metrics, Chapter 8, let me see if I can find anything that applies. Seems like a planned value type of calculation.