Forum Discussion
How to change a date structure
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
Anonymous 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.
2 Replies
Anonymous 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.