How to do addition of two columns one is date and other is number In Transform Dat of Power BI

[hb0135]

Hello,
In Excel, i have added two columns in one column,the data  it is in date format, and the other is in number format I need to do the same in Transform Data. 

[Jihwan_Kim · Accepted solution]

Hi,

I suggest performing this in Power Query Editor.

I tried to create a sample pibx file like below.

Please check the below picture and the attached pbix file.

M codes that I used are, 

Number.From - PowerQuery M | Microsoft Learn

Date.From - PowerQuery M | Microsoft Learn

These help to convert date data type to number data type or convert number data type to date data type.

let
    Source = data_source,
    #"Added Custom" = Table.AddColumn(Source, "date", each Date.From ( Number.From([bookdate]) + [add] ), type date)
in
    #"Added Custom"

[hb0135]

Hi Jihwan_Kim 

Thanks for the help it really work.