How can I bypass the Excel row limit of 1,048,576 rows

Date.AddDays is a great function that allows us to add days onto a column of Date or DateTime values in the PowerQuery editor. Adding days onto a date value isn’t something that you can do through PowerQuery’s user interface. However, because it’s quite a simple function to use, it’s a great starting point for learning M code.

In the video above I show how this function can be used to create a payment due date column in an accounts payable report where we only have an invoice date column. We could use the same function for an Account Receivable report to show when we’re expecting cash in. Both together would be really useful for a cashflow forecast!