Forum Discussion
Calculate Dates without the Weekends
Hello guys,
I would like to calculate a date in Power Bi that does not include the weekend days. A quick example:
I have today's date 06/17/21 and want to sum up 5 business days on the date. That means the calculated date should then be 06/24/21.
| Last confirmed date | Time until delivery | Delivery date |
| 06/17/21 | 5 | 06/24/21 |
Thanks in advance for your help.
Greeting Lukas
Hi, Anonymous
Please check the below picture and the sample pbix file's link down below.
delivery date measure =
VAR dateranking =
RANKX (
FILTER ( ALL ( Dates ), Dates[Day of Week] <> 6 && Dates[Day of Week] <> 0 ),
CALCULATE ( MAX ( Dates[Date] ) ),
,
ASC
)
VAR selecteddays =
SELECTEDVALUE ( 'Until Delivery'[Until Delivery] )
RETURN
MAXX (
FILTER (
ALL ( Dates ),
RANKX (
FILTER ( ALL ( Dates ), Dates[Day of Week] <> 6 && Dates[Day of Week] <> 0 ),
CALCULATE ( MAX ( Dates[Date] ) ),
,
ASC
) = dateranking + selecteddays
),
Dates[Date]
)
1 Reply
- Jihwan_Kim
Super User
Hi, Anonymous
Please check the below picture and the sample pbix file's link down below.
delivery date measure =
VAR dateranking =
RANKX (
FILTER ( ALL ( Dates ), Dates[Day of Week] <> 6 && Dates[Day of Week] <> 0 ),
CALCULATE ( MAX ( Dates[Date] ) ),
,
ASC
)
VAR selecteddays =
SELECTEDVALUE ( 'Until Delivery'[Until Delivery] )
RETURN
MAXX (
FILTER (
ALL ( Dates ),
RANKX (
FILTER ( ALL ( Dates ), Dates[Day of Week] <> 6 && Dates[Day of Week] <> 0 ),
CALCULATE ( MAX ( Dates[Date] ) ),
,
ASC
) = dateranking + selecteddays
),
Dates[Date]
)