1 Reply Latest reply on Feb 5, 2019 12:06 AM by Norbert Maijoor

    Creating annual expected vacation plan

    Abdullah Almansour


      I'm stuck on building a schedule to identify the expected employee vacations for this year.

      I have start date and end date for each employee. However I couldn't figure out how to do it.


      any idea ?



        • 1. Re: Creating annual expected vacation plan
          Norbert Maijoor

          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,