Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can I add 3 days to TODAY() skipping the weekend?
For example:
Solved! Go to Solution.
Hi!
You can combine IF()/SWITCH() and WEEKDAY() (WEEKDAY function (DAX) - DAX | Microsoft Learn) for this. Something like:
Today + 3 =
if(
WEEKDAY( TODAY() + 3, 2) <= 2, //If weekday Mon or Tue...
TODAY() + 3, //...add 3
TODAY() + 5 //Else add 5
)
Hope this helps!
hi @TimmK
try to add a column with this:
hi @TimmK
try to add a column with this:
Hola estimado, espero me pueda apoyar, utilice esta formula:
DayPlus3 =
VAR _day = WEEKDAY([DATE],2)
RETURN
IF(
_day>=1&&_day<=2,
[DATE]+3,
[DATE]+5
)
pero cuando la fecha cae en sabado o domigo me da una fecha incorrecta, por ejemplo:
tengo la fecha 29/04/2023 + 3 dias habiles la fecha correcta debe ser "03/05/2023 " pero a mi me da un dia de mas, me da la fecha 04/05/2023, me podria apoyar para saber donde esta el error.
Hi!
You can combine IF()/SWITCH() and WEEKDAY() (WEEKDAY function (DAX) - DAX | Microsoft Learn) for this. Something like:
Today + 3 =
if(
WEEKDAY( TODAY() + 3, 2) <= 2, //If weekday Mon or Tue...
TODAY() + 3, //...add 3
TODAY() + 5 //Else add 5
)
Hope this helps!
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |