Forum Discussion

jimpatel's avatar
jimpatel
Post Patron
2 years ago
Solved

date add

Hi,   Thanks for looking at my post.   I have below formula and can anyone help me to modify this to add 2 days on top of this please?    Date = SWITCH(TRUE(),          WEEKDAY( 'Table'[Recei...
  • Elcin_7's avatar
    Elcin_7
    2 years ago
    Hi,
     
    Date  = SWITCH(
                TRUE(),
                WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3+2, 'Table'[ReceiptDate] + 0+2
    )
     
    another version
     
    Date  = SWITCH(
                TRUE(),
                WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] +5, 'Table'[ReceiptDate] + 2
    )
     
    I hope, I understood the requirement correct.
Elcin_7's avatar
Elcin_7
Helper I
2 years ago
Hi,
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3+2, 'Table'[ReceiptDate] + 0+2
)
 
another version
 
Date  = SWITCH(
            TRUE(),
            WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] +5, 'Table'[ReceiptDate] + 2
)
 
I hope, I understood the requirement correct.