Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
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
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |