Forum Discussion
Solved
Nested if statement based on dates for New Column
Hope you can kindly assist. I'm trying to write a nested if statement for a new column I created, but I'm having trouble with the syntax. My new column is called "WEEK #" where it is the number of we...
Try using the datediff function instead... Something similar to this:
Weeks_After_Start_Date = DATEDIFF("1/30/2023", 'Table'[Completed Date], WEEK)
Thank you! That is so much easier 🙂