How to convert number into date

[Anonymous]

Hello,

The raw data contains the year and period (month) as alphabets. How do I convert it to date? I want to convert it to date and then create a relation to connect it with the date table that I have created.

When I click on the ABC symbol in the year column and convert it to date then all values are converted to 01/01/2020. I want to use the month from the period column.

Thanks

[amitchandak · Accepted solution]

@Anonymous , Try a new column (DAX)

New date = Date([Year],[Period],1)

[az38]

Hi @Anonymous 

you need to create a new custom column.

in power query syntax will be

= #date(Number.FromText([Year]),Number.FromText([Period]),1)