Power Query: Date + Number of Days Not working in formula

[robtops]

Morning, I've just started using power query which looks like being a really useful tool.

I'm preparing a dataset ready for use in a Power Pivot model.

As part of this I've added a number of calculated columns but am having trouble getting one of these to work.

Its pretty basic and is adding an existing date to a number of days column (=[Bill_Date] + [Payment_Terms]). In Excel this gives me a new date but in Power Query I'm getting this error:

We cannot apply operator + to types date and Number

Any ideas as to how I go about achieving what I'm after with Power Query?

Thanks very much and if you need any more info let me know

 

[Ozeroth]

Hi robtops,
Power Query is fussy about types and won't let you simply add a Date and an Integer.
The function Date.AddDays should do the trick. Something like
Date.AddDays([Bill_Date], [Payment_Terms])

 

[robtops]

Perfect that works so thanks a lot for your help