# Calculation add working days to date

Hello all, this is my first topic i please here, hope you can help me with the following question:
i have two tables, trying to create a measure:

1. calendar: with working days, means that I have a column in my calendar which gives a β1β, if it is a working day
2. order table: it contains the date on which we created the order and a leadtime for the product in working days

my question is e.g. if i place the order on 15th of march [order-date] and the [lead time] e.g. 12 working-days, on which date should i receive my product

I hope my question is clear, thanks a lot for your help in advance, kind regards

Franzsampledate_order.pbi.pbix (115.6 KB)

Thanks,

Hello nick, thanks in advance for your help, please find information in picture, blue is input and green would be the desired result.

kind regards
Franz

@Franz,
Can you upload the pbix file?

Thanks,

sampledate_order.pbi.pbix (115.6 KB)

i hope it works, thanks a lot
Franz

@Franz,
Take a look at the attached file. But I broke this down into a few measures, but basically I filtered the date table from the order date till order date + lead time. I was then able to get the count of non-working days. Using those two bits of info I was able to get to the final result. If you put all the measures on the table it could help you see it if you are having trouble, but there is no need for all those intermediate measure to be on the table. you could actually build this into one formula, but maybe these measures could be used elsewhere.
sampledate_order.pbv2.pbix (116.1 KB)

``````Order Date Plus Lead Time =

Total Working Days =
CALCULATE(
COUNTROWS( 'table calendar'),
DATESBETWEEN( 'table calendar'[Date], MAX('table order'[date of order]),[Order Date Plus Lead Time]),
'table calendar'[working day] =1,
ALL( 'table order')
)

Total NonWorking Days =
CALCULATE(
COUNTROWS( 'table calendar'),
DATESBETWEEN( 'table calendar'[Date], MAX('table order'[date of order]),[Order Date Plus Lead Time]),
'table calendar'[working day] =0,
ALL( 'table order')
)
``````

`Total Day Offset = [Total Days Lead Time] + [Total NonWorking Days]`

``````Final Desired Result =
IF(
NOT(
'table calendar'[Date],
[Total Day Offset]-1,
DAY)
)
``````

Nick,

1 Like

Hi Nick, thanks a lot, exactly what i need, but i didnβt think that this is that complex. :-)
have a nice weekend, kind regards
Franz

@Franz
Me and you both

There could be a better solution, but thatβs the best I could come up with and it appears to work.