Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JacekM_PL
Frequent Visitor

Adding specific number of working days to date in one column

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?

JacekM_PL_0-1704271665716.png

 

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

1 REPLY 1
amitchandak
Super User
Super User

@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...

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.