How to transform the month(Jan, Feb, Mar...Dec) to a Date format

[RyanLau]

Hi,

My data has no date column and has a month column(Jan, Feb, Mar...Dec) and a year column respectively, can I transform it with DAX?

For example 

Month    Year

| Jan     |  2022|   --> 1/1/2022

Thanks

Ryan

[v-zhangti · Accepted solution]

Hi, @RyanLau 

You can try the following methods.

Date = DATEVALUE('Table'[Year]&"/"&'Table'[Month]&"/"&"1")

Is this the result you expect?

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.

[RyanLau]

Hi Charlotte,

It really works, many thanks!

Regards

Ryan

[mh2587]

combine date and year column then change the data type to Date