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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Syndicate_Admin
Administrator
Administrator

Add business days to a date

Dear, how are you?

I am a bit new to this topic and I am trying to make a calculation that I could not ....... I have a table that has a date which is generated when entering a request in my system, also with a series of additional data, within which I have an ID that identifies a supplier, which has x days defined to comply, but those days should only be considered the working days.

Result = OC Date + Comp Days (only counting working days)

Someone can help me find how to solve this...... would appreciate it very much

RodriCP_0-1691762685870.png

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

Thank you very much for the answer, but what I need is.
I have a departure date and I have other data which indicates the number of (business) days that I have to add to that departure date.
I have only managed to add the days to my departure date, but these are added to me continuously

FechaFinal = (VW_EvaProData[FechaOC] + (LOOKUPVALUE(Commitment[Days],Commitment[CodAux],VW_EvaProData[CodAux])))




StuartSmith
Power Participant
Power Participant

Struggling to undestand the question (although your English is better than my Spanish), but have you looked into "NETWORKDAYS" to get just the Business/Week/Working days.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.