How to change a date structure

[gupta_diksha]

Hi,

I hope you all are doing fine. 

I am confronting a problem related to dates. I have imported a text file into Power BI and there is one column of date in which date structure is 20200101. Is there is way to change this date structure to a valid date structure within Power BI. 

Thank you in advance. 

Best Regards

[Greg_Deckler · Accepted solution]

@gupta_diksha In Power Query, change the type to Text then add another step to change the type to Date. For some reason this works versus going directly from numeric to date.

[gupta_diksha]

Thank you so much