Add date if it comes on a Tuesday and Wednesday

[skv17]

Hi team,

for example if a date on a column arrival lands on a tuesday or a wednesday add 2 days if tuesday and add 1 day if it is thursday.

so if date is 24/10/2023 then add 2 days so date is 26/10/2023

and if date is 25/10/2023 then add 1 days so date is 26/10/2023

need on m query power bi as a custom column.

[Ahmedx]

try this

you can change {3,4} as you wish

Column =  
VAR _Dayweek = WEEKDAY('Calendar'[Date])
RETURN
 SWITCH( TRUE(),
  _Dayweek in {3,4} , 'Calendar'[Date]+2,
  _Dayweek in {5},'Calendar'[Date]+1,
  'Calendar'[Date])

 

[Idrissshatila · Accepted solution]

Hello @skv17 ,

First of all, you create a day column out of the date column

then you use the following formula in the custom column

if [Day Name] = "Tuesday" or [Day Name] = "Wednesday" then Date.AddDays([Date], 2) else if [Day Name] = "Thursday" then Date.AddDays([Date], 1) else [Date]

then convert the column type to date