Custom column for extracting data from current week , +1 , +2

[sara1312]

Hi , The start of the week date is every monday.

And I tried to add today the below query to get the data for current week +1 if the file is refreshed on monday to wed
and the week + 1 , +2 if refreshed on Thursday and Friday .

The below returns only the week +1 not the week.

= Table.AddColumn(#"Inserted Day Name", "Custom", each if List.Contains ({"Monday","Tuesday","Wednesday"}, [Day Name]) then Date.IsInNextNWeeks([Start of Week Date],1) or Date.IsInPreviousNWeeks([Start of Week Date],0) else Date.IsInNextNWeeks([Start of Week Date],2)

 

[sara1312]

Hello Everyone, could you help on this please ?

 

[RoryA]

Why have you got this part in there: or Date.IsInPreviousNWeeks([Start of Week Date],0)