98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Adding Workdays to Dates
Adding Workdays to Dates
Resolved · Low Priority · Version 2016
Wed 22 Apr 2020, 13:35Delegate 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:22Trainer 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:16Delegate 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:33Trainer 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
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:General ShortcutsCtrl + S: Save the report or dashboard. |
