Adding specific number of working days to date in one column

[JacekM_PL]

Hello Power BI community,

I have a question:

Can I add specific number of working days to column with dates in Power BI either in power query or in the modeling view?

I would love to have a new column which will show the new date (considering added working days) for each row that contain the date, so the blank ones would remain blank.

Would that have to be a new column created?

Thanks in advance,

Jack

[amitchandak]

@JacekM_PL , refer example in comment for new column

Traveling Across Workdays - What is next/previous Working day
https://community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calenda...