Combining rows based on unique id, and combining information

[TBenders]

Hi,

This is my first post on this forum, but I've been 'lurking' around for a while, learning as I go. Hopefully one of you BI-wizards can help me out with my particular case for which I couldn't find an anwser.

In my Power BI I have a table with id's and dates. I'm trying to combine the rows based on the id (so this column will be a unique identifier) while combining the data from the differen't columns.

Example of my table:

id	StartDate	FollowupDate	FinishedDate
101	1-1-2016	null	null
101	null	1-2-2016	null
101	null	null	2-2-2016
102	3-1-2016	null	null
102	null	null	5-1-2016
103	3-1-2016	null	null

Result I'm trying to get:

id	StartDate	FollowupDate	FinishedDate
101	1-1-2016	1-2-2016	2-2-2016
102	3-1-2016	null	5-1-2016
103	3-1-2016	null	null

I have a feeling this should be easy to do, but I've been searching around for quite a while without result.

Any idea how I can accomplish this in Power BI?

[ImkeF]

I would create 2 tables which will be connected in the data model via UniqueID:

1) Header

2) Details:

[TBenders]

Amazing, this did exactly what I was looking for. 

Thanks Imke!