Create new columns/measure from different columns in a same table

[MianAhsan]

Hi all,

I'm trying to create two new calculated columns/measures (Start Date & End date) from a project table. Where I need to filter data based on the task, if task="Start" then it is start date and if task="Ship" then end date. I have data shown below.

Project	Task	Date
Project A	Start	27-Jan-22
Project A	Definition	30-Sep-22
Project A	Development	1-Jan-24
Project A	Testing	1-Feb-25
Project A	Ship	1-Jun-25
Project A	Quality	1-Feb-26
Project B	Start	2-Jan-22
Project B	Definition	20-Sep-22
Project B	Development	20-Jan-24
Project B	Testing	15-Feb-25
Project B	Ship	16-Jun-25
Project B	Quality	17-Feb-26
Project B	Qualification	10-Mar-26

And I want to have results like that:

Project	Start Date	End date
Project A	27-Jan-22	1-Jun-25
Project B	2-Jan-22	16-Jun-25

My end goal is to see the percentage of project completion.

Can you please help me here? I'm new to PBI.

Thanks.

Regards,

Mian 

@lbendlin , @amitchandak 

[MianAhsan]

Hi @zenisekd ,

I have another table where most of the information related to the projects is available, and each row (line) represents one project. I can add the start and end dates there too. 

End goal is to create % of project completion and show it in a table with other project details. 

[zenisekd · Accepted solution]

For end date change "Start" in the formula to "Ship".

[MianAhsan]

Thank you for your quick response. This is the right solution I was looking for. 

[zenisekd]

Is it new columns that you want
or
a summarizing new table, where each project represents one line, as you showed in the picture
or
you have two tables - one with projects and second where the projects have their tasks and your goal is to add to the project table two new columns based on the second (task) table?