How can I use the Left Anti join function in PowerQuery?

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!

If you’d like to follow along with the video, then download the Excel file in the link to the right, and connect Power BI or PowerQuery in Excel to the file:

Other useful Info and links

 – If you’d like to visit the Microsoft M Code library then click here