Adding Workdays to Dates

Resolved · Low Priority · Version 2016

Wed 22 Apr 2020, 13:35 Delegate Lesley said...

Lesley has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course

Adding Workdays to Dates

Hi, I have some data which is taken from our system to record the date that invoices were created. We have a turnaround of 5 working days to get the invoices processed through the system for approval. I have a date table and I am looking to figure out how I can add working days onto the created date to get our SLA date. The date table is linked by 'Date' to the invoices table 'Created Date'. Thanks

Wed 22 Apr 2020, 15:22 Trainer Jens said...

RE: Adding Workdays to Dates

Hi Lesley,

Thank you for the forum question.

We do not unfortunately have a Workday function in DAX,

You can test if the day number is different from day 6 and 7, but you will end up with some very complicated DAX.

What I suggest you should do. If it is always plus 5 working days I would add a column to the date table (in the Excel file) and write the function =Workday([Dates], 5). Were [Dates] is the column which are the primary key in the date table.

I hope this will do what you want.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 23 Apr 2020, 10:16 Delegate Lesley said...

RE: Adding Workdays to Dates

Hi Jens
Thank you for your help with this, that has worked and probably a lot easier than what I was trying to do in Power BI.

Thu 23 Apr 2020, 10:33 Trainer Jens said...

RE: Adding Workdays to Dates

Good Lesley,

I am happy that my solution was useful.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

General Shortcuts

Ctrl + S: Save the report or dashboard.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Ctrl + C: Copy selected items.
Ctrl + X: Cut selected items.
Ctrl + V: Paste copied or cut items.
Ctrl + A: Select all items.
Ctrl + N: Create a new report or dashboard.

View all Power BI hints and tips