Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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]
)
https://www.dropbox.com/s/7bkng1984zav4qm/keluv2.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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]
)
https://www.dropbox.com/s/7bkng1984zav4qm/keluv2.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |