Custom column Date.from dataset values

[judddonnelly]

I have 3 columns in my dataset that represent Year, Month and Day.  They are call Y, M, D respectice and are all text values.  Trying to create a custome column that return a date from these.  Tried Date.From(#date([Y],[M],[D])) but getting an error.

[CNENFRNL]

= Table.AddColumn(Source, "date", each Date.From(Text.Combine(Record.ToList(_), "/")))

= Table.AddColumn(Source, "Date", each #date(Number.From([Y]),Number.From([M]),Number.From([D])))

[Tanushree_Kapse]

Hi @judddonnelly 
Create this Calculated column:
Date= DATE(YEAR(Y), MONTH(M), DAY(D))

Mark it as a solution if it answers your question.

Thanks!

[judddonnelly]

[judddonnelly]

[judddonnelly]

[Tanushree_Kapse]

@judddonnelly ,

Not in the power query.

Create a calculated column...in your table in the data view.

Write the DAX for the column.