date add

Question

Hi,&nbsp;Thanks for looking at my post.&nbsp;I have below formula and can anyone help me to modify this to add 2 days on top of this please?&nbsp;&nbsp;Date = SWITCH(TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WEEKDAY( 'Table'[ReceiptDate] + 1,1) = 7 , 'Table'[ReceiptDate] + 3, 'Table'[ReceiptDate] + 0)

elcin_7 · Accepted Answer

Hi,&nbsp;Date&nbsp; =&nbsp;SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;WEEKDAY(&nbsp;'Table'[ReceiptDate]&nbsp;+&nbsp;1,1) =&nbsp;7&nbsp;,&nbsp;'Table'[ReceiptDate]&nbsp;+&nbsp;3+2,&nbsp;'Table'[ReceiptDate]&nbsp;+&nbsp;0+2)&nbsp;another version&nbsp;Date&nbsp; =&nbsp;SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;WEEKDAY(&nbsp;'Table'[ReceiptDate]&nbsp;+&nbsp;1,1) =&nbsp;7&nbsp;,&nbsp;'Table'[ReceiptDate]&nbsp;+5,&nbsp;'Table'[ReceiptDate]&nbsp;+ 2)&nbsp;I hope, I understood the requirement correct.

Forum Discussion

date add

2 Replies

Related content

Add months to date

Add weeknr to date hierarchy

Add a Custom Column Containing Today's Date

Add days to date in PowerQuery

Date function to add minutes