Forum Discussion
Solved
Calculating a due date in Power Query
Hi, I’m trying to calculate a due date. I have a date column. I want to add 60 days to the date column to come up with the due date in a new column. Drawing a blank on how to do this in Power...
I found the answer in the forums. BA_Pete had some code that did the trick.
Date.AddDays(__todayDate, 7)
I just replaced the (__todayDate, 7) with my date column name and 60. Did the trick.
I found the answer in the forums. BA_Pete had some code that did the trick.
Date.AddDays(__todayDate, 7)
I just replaced the (__todayDate, 7) with my date column name and 60. Did the trick.