Subtract or Add #s to a date field in M Query

[Anonymous]

I would like to be able to subtract or add a # of days from a date field in the query editor.   In one column I have number of days (5,300, 60) and in another column i have dates 01/01/2018.  Is there a custom column function that will subtract or add?

Example......   01/01/2018 + [Date Field] (5) = 01/06/2018 

Thanks!

[MarcelBeug]

Yes: Date.AddDays.

[Anonymous]

When I use the formula for dateadd it doesn't do the calculation.

Date.AddDays([Start Date], [Promote_or_Defer__c])

[v-chuncz-msft · Accepted solution]

@Anonymous,

Change the data type if necessary.

Date.AddDays(Date.From([Start Date]), Number.From([Promote_or_Defer__c]))

[MarcelBeug]

let
    Source = #table(type table[Start Date = date,Promote_or_Defer__c = Int64.Type], {{#date(2017,12,18),-10},{#date(2017,12,18),10}}),
    #"Added Custom" = Table.AddColumn(Source, "Resulting Data", each Date.AddDays([Start Date],[Promote_or_Defer__c]), type date)
in
    #"Added Custom"