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:
Go to Solution.
Created a weekday column then used this in a new column:
View solution in original post
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!