how to create new date column from individual date, month and year colunns ???

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Let's give an assumption: 

In one table I have Columns:

DAY = 01;

MONTH = 01, 02, 03 and so on; 

YEAR = 2019

Outcome: A Custom column that joins all three columns above and shows in date format DD-MM-YY (01-01-2016, 01-02-2016, 01-03-16

Here is the query I used:

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjBU0oEQRgaGZkqxsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Day = _t, Month = _t, Year = _t]),
#"Added Custom" = Table.AddColumn(Source, "Custom", each [Day] & "-" & [Month] & "-" & [Year])
in
#"Added Custom"

[az38]

Hi @Anonymous 

I see there is the best and easiest way:

In power Query press Custom Column in the Add Column pane and write a formula like this

= Text.Combine({Text.From([Day]), ".", Text.From([Month]), ".", Text.From([Year])})

Exactly format depends on your localization. Next transform your new column as Data type