This content has been marked as final.
Show 1 reply
-
1. Re: Creating annual expected vacation plan
Norbert MaijoorFeb 5, 2019 12:06 AM (in response to Abdullah Almansour)
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
-
planning_nalmai_v10.5.twbx 17.3 KB
-