How subtract 1 working day from date column

EugenioJunior · ‎07-22-2019

Hi,

I have a date column [date of birth] and need to subtract a variable number of working days from that data.

How can I do this?

If the date field is not working day, then I need to advance this date to the most working day before the date given in the column.

parry2k · ‎07-22-2019

@EugenioJunior you can simply substract

new date = Table[Date of Birth] - <value you want to subtract>

and you can check if new date Date of week is Sat or Sunday, add # of days accordingly

Spoiler

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.