Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
solved it:
Created a weekday column then used this in a new column:
solved it:
Created a weekday column then used this in a new column:
User | Count |
---|---|
56 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |