Forum Discussion

GeDemu's avatar
GeDemu
Copper Contributor
Jun 16, 2022

Power Query: List with values and names split across working days

Hello all,

 

I am wondering if it will be possible to split values from a list to working days.

 

Document i have: List of over 100 individuals with the total working days in a month.

 

Document i want: List of those 100 individuals split over working days of a certain month and the total working days split over that period.

 

I am using latest version of excel and have Power Bi as well if needed.

 

Example: 

What i have

Person A15
Person B20
Person C18

 

Example:

What i want

 

Person A01/06/2022 (DD/MM/YYYY)1
Person A02/06/20221
Person A03/06/20221
Person A05/06/20221
Person Aetcetc until the total working days is filled.
Person B01/06/2022 1
 02/06/20221
 03/06/20221
 05/06/20221
etc etc until the total working days is filled.

 

 

excel
Formulas and Functions
Macros and VBA
power bi

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jun 16, 2022

    Hi GeDemu 

     

    Start date not mentioned so I assumed 1st working day of current Month/Year (easy to change)

    Function https://www.thebiccountant.com/2022/02/21/excel-workday-equivalent-in-power-query-and-power-bi/

    See attached file

Resources