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.   Documen...
excel
Formulas and Functions
Macros and VBA
power bi
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