Change a date to the following Monday if it falls on a weekend

rjs2 — Wed, 16 Oct 2019 16:30:24 GMT

I am trying to evaluate a date field and change the date to the following Monday if it falls on a weekend. I tried to use the WEEKDAY and DATEADD in an IF statement. I keep getting :

"A Date Column containing duplicate dates was specified in a call o function 'DATEADD'. This is not supported."

This is my statement:

Date Received = IF(WEEKDAY('Table'[DATE.FIELD],1)=1,Dateadd('Table'[DATE.FIELD],1,DAY))

I was going to do an embedend IF statement to calculate the Saturday and Sunday days to be the following monday, else use the date.

Re: Change a date to the following Monday if it falls on a weekend

rjs2 — Thu, 17 Oct 2019 15:11:41 GMT

solved it:

Created a weekday column then used this in a new column:

Date Received = If('Table'[Weekday]=7,'Table'[DATE]+2, If('Vetting Query'[Weekday]=1,'Table'[DATE]+1,'Table'[DATE]))

topic Re: Change a date to the following Monday if it falls on a weekend in DAX Commands and Tips

Change a date to the following Monday if it falls on a weekend

Re: Change a date to the following Monday if it falls on a weekend