Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

WorkDays Function in Power Query M

I am trying the create a function that replicates the Workdays function typically found in Excel.   I have gotten so far;   //fnWorkDays let func = (StartDate as date, WorkDays as number) => le...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous ,
I don't understand the requirment, unfortunately.
Could you please give an example with sample values (before and desired after)?
Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ImkeF  , 

Apologies if i was not clear on my requirement . Request :  i just want to retrive the last working day and pass this date as a parameter in another script to fetch data . 

 

So from this function , all i want is to retreive the last working day . E.g. If today is Monday (31 May 2021) , then my last working day is Last friday ( 28 May 2021) .  

For clarity - all days Mon-Fridays are working day in our firm , which includes all public holidays as well, so data is made available from Monday to Friday in our DWH . 

 

 

The above function you had shared is great but i would need to pass a date there , in my case the start date would always be today . i tried to pass the start date as (DateTime.Date(DateTime.LocalNow())) but was unsuccessful .

Hope you can help me here .

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    ImkeF  please ignore my requirement , i got the solution working now . Again thanks for your time .