Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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:
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.