How to transform months and years from text format to date format

[alona]

Hello,

Please advise how can I change the columns definition from text to date.

In the exist columns the values appears as Jan Feb... in text format and the years as 2017 2018 in text or decimel number format.

Thank you,

Alona

[v-qiuyu-msft]

Hi @alona,

Assume sample data looks like below: 

You can create a calculated column below: 

Date = DATE('Table1'[Year],SWITCH([MONTH],"Jan",01,"Feb",02,"Mar",03,"Apr",04,"May",05,"Jun",06,"Jul",07,"Aug",08,"Sep",09,"Oct",10,"Nov",11,"Dec",12),1)

Best Regards,
Qiuyun Yu 

[alona]

Thank you very much. It was very helpful.