topic date add in DAX Commands and Tips

date add

jimpatel — Thu, 09 May 2024 08:42:55 GMT

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'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3, 'Table'[ReceiptDate] + 0

)

Elcin_7 — Thu, 09 May 2024 09:30:06 GMT

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.

jimpatel — Thu, 09 May 2024 10:07:01 GMT

Perfect

Thanks a lot