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