Change text data type to date data type

[Anonymous]

Hi,

I have fiscal Period column and I want to convert in to “Date” format.When  tried to change data type to “date” format It has created very weired number.

I do not have any DATE column in my dataset.

Thanks

[Anonymous]

Hi @Anonymous 

What is the error you are getting?

You can try this after converting it to date:

select the format of your date from this dropdown:

let me know if this works.

Thanks,

Tejaswi

[Anonymous]

Hi,

When i have chaged Data Type to Date,I am getting below weird numbers,

[HotChilli · Accepted solution]

In Power Query, change the column type to Text.

Add a column like this

Text.Combine({[Fiscal Period], "01"})

That just adds 01 to the end of the data.

Change the new column type to Date

[Anonymous]

Thank you so much ...

[Anonymous]

Hi,

One more information i want to convert it to YYYYMM.Thanks