This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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
Solved! Go to Solution.
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.
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.