Forum Discussion

krutec's avatar
krutec
Regular Visitor
2 years ago
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 Query.    Any help would be appreciated.

 

Thanks,

Rick

Need Help
  • krutec's avatar
    krutec
    2 years ago

    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.  

1 Reply

  • krutec's avatar
    krutec
    Regular Visitor
    2 years ago

    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.