Hi Abdullah,

Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

1. Pivot your dataset

2. D1. Enddate calc: {fixed [Employee]:min(if [Pivot Field Names]='Enddate' then [Pivot Field Values] end)}

3. D2. Startdate calc: {fixed [Employee]:min(if [Pivot Field Names]='Startdate' then [Pivot Field Values] end)}

4. M1. Duration: (datediff('day',[D2. Startdate calc ],[D1. Enddate calc]))

5. Drag the required objects to the indicated locations

Hope it helps,

Regards,

Norbert