Forum Discussion

walnei's avatar
walnei
Helper III
10 years ago
Solved

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

 

 

  • Hi,

     

    You can add a custom column with this formula:

     

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

3 Replies

  • arify's avatar
    arify
    Microsoft Employee

    Hi,

     

    You can add a custom column with this formula:

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable

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