DAX: How to convert column from text to date?

[PBI_newuser]

Hi, I have year, month and date columns in a table. 

I tried to create column Date = Date (Year, Month, Date) but the format is store as text and couldn't be converted to date.

Year	Month	Date
2021	10	25
2020	4	12
2020	5	6
2019	3	6

[v-zhangti · Accepted solution]

Hi, @PBI_newuser 

 The table year, month, day are text format, the use of DATE function can be converted to date format.

Date = DATE([Year],[Month],[Day])

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@PBI_newuser Try to create date column in PowerQuery. There you can convert text to date without problem.