cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
walnei Member
Member

Sum Date + Number

Hello friends. Could help me with the following question ?   I'm trying to create a custom column in power query with the following parameter .   I have 2 columns , column A that has dates and the B column has numbers , I would add the column (data) + Column B (number) and the result would come as a date.  Example: Column A = 01.01.2016 ( Date ) Column B = 10 (number) Sum of Two would = 01.11.2016

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
arify Established Member
Established Member

Re: Sum Date + Number

Hi,

 

You can add a custom column with this formula:

 

Date.AddDays([A], [B])

3 REPLIES 3
arify Established Member
Established Member

Re: Sum Date + Number

Hi,

 

You can add a custom column with this formula:

 

Date.AddDays([A], [B])

walnei Member
Member

Re: Sum Date + Number


Thanks for the solution

tera12 Regular Visitor
Regular Visitor

Re: Sum Date + Number

Thank you, this was exactly what I needed, and it worked perfectly!